OK maybe this article is not THAT important LOL but it was a great quote by Obama so I figured I’d work it in LOL Please know what Recovery Mode your databases are in and your recovery requirements and then back them up accordingly. Too often I see databases that are in a Full or [...]
Posts Tagged ‘Transaction Log’
Another Reason SQL 2000 should just go away! :)
Quick without looking it up… what does this script do: SELECT * FROM dbo.sysfiles WHERE (status & 0×40) <> 0 So if you’re like me and don’t have all the bit compares memorized for all the tables you probably didn’t know that this is how (in SQL 2000) you would query the current database to find all the transaction log files. Every now and [...]
Transaction Log Backups – Doublecheck Script
Have you ever wanted a quick way to check that all of your databases that are either in FULL or BULK_LOGGED recovery mode have transaction log backups setup? The script below is a nice safety net to ensure that all of your non-simple recovery mode databases have transaction log backups setup. Bottom line… if you [...]
