Welcome to the first Meme Monday! Today’s meme is “Write a SQL blog post in 11 words or less”, and here is my entry: Taking backups is half the job, don’t forget to restore them Tag Time Grant Fritchey (blog @GFritchey ) Aaron Bertrand ( blog @AaronBertrand ) Jorge Segarra ( blog @SQLChicken ) Great idea [...]
Posts Tagged ‘Backups’
SQL Databases That Have Not Had a Full Backup in x Days
So something that you should do regardless of the alerts, notifications, etc that you have setup is to just have a daily sanity check on your database backups. Sure you don’t have any failed jobs but what if the job never attempted to run in the first place like it was supposed to? If a [...]
COPY_ONLY Backups
In SQL 2005 a COPY_ONLY option became available for backing up your databases. What COPY_ONLY does is take a backup (full or t-log) without affecting the backup/restore cycle. This is a great new feature as quite often DBAs are asked for an out of sequence backup to be taken to restore to a different environment. [...]
