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’
I am not the first DBA to take up this cause… but I am determined to be the last
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 again I take for [...]
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 have [...]
