T-SQL Tuesday #024 – Using SYSTEMRESTRICTSCHEMA Function in MDX to Query DMVs This blog entry is participating in T-SQL Tuesday #024, hosted this month by Brad Schulz (Blog). 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…

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:

T-SQL Tuesday #17: Using Apply to Demystify Deadlocks This blog entry is participating in T-SQL Tuesday #17, hosted this month by Matt Velic (Blog|@mvelic). 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…

T-SQL Tuesday #15: Database Mirroring Automation This blog entry is participating in T-SQL Tuesday #15, hosted this month by Pat Wright (Blog|@SqlAsylum). 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…

T-SQL Tuesday #012 – the DBA as a Modern-day Specialist This blog entry is participating in T-SQL Tuesday #012, hosted this month by Paul Randal (Blog|@PaulRandal). 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…