Tag Archives: T-sql Tuesday

T-SQL Tuesday #19 – Beyond Backups

[caption id="" align="alignright" width="150" caption="T-SQL Tuesday #19 - Disasters & Recovery"][/caption]
This blog entry is participating in T-SQL Tuesday #19, hosted this month by Allen Kinsel (Blog|@sqlinsaneo). You are invited to visit his blog to join the blog party. You are welcome to write your own participating blog post for the party or just to read more blogs participating in this month’s theme: Disasters & Recovery.

Any DBA worth his or her salt knows by now that they’d better have backups of their databases. I’m often surprised by just how many people aren’t backing up their system databases. I see a lot of people preparing for the loss of a database, but very few people preparing for the loss of the whole server. So what would you do if you lost a whole server? Restore user databases, and then what?

Part of the issue is that there are hundreds of DBAs espousing database backups, but very few talking about what else you need. don’t stop at database backups. You need to go beyond just backups.

These are some of the key things you could be losing if you do not back up your system databases and system configurations: … Read More →