Category: MSSQL

0

mssql get the backup information with copy_only information.

I need to find a way to see if the backup chain where broken. On my search I found this could script, created by “hot2use”I have found this script on a forum.https://dba.stackexchange.com/questions/204883/how-to-tell-if-a-backup-log-chain-is-broken The script...

0

MSSQL How long will data be in cache/buffer

How fast is data leving the cache, when it not access again. With this query, you can see how fast data will get expire, and overwritten by new data in the cache. Witch the...