Category Archives: Disaster Recovery

The most recent backup problem

When I first began this blog, back at the beginning of my DBA career, it was purely a place for me to keep queries, things I was learning, processes and handy links. This is one of those posts, there’s nothing new or ground-breaking … Continue reading

Posted in Disaster Recovery, Powershell, SQL Server | 1 Comment

Another great reason to enable remote admin connections

I recently came cross another great reason to enable the remote admin connections server configuration on SQL server. If you don’t know what the DAC is I’m not going to go into detail here so check out these posts here, … Continue reading

Posted in Disaster Recovery, Security, SQL Server | Leave a comment

The full text error and why I was happy to see it.

The Situation: I was recently involved in the migration of a group of core databases from three SQL Server 2005 instances to three SQL Server 2012 instances. There were quite a few moving parts that needed to be considered as part of … Continue reading

Posted in Database options, Disaster Recovery, SQL Server | Tagged , , , | 2 Comments

Quick Tip: Migrating a SQL Server Mirroring Witness server.

If you’re like me, you might be thinking “I want some more things to think about when I migrate between SQL Servers.” … No? Okay, fair enough. There’s a whole list of things to think about when migrating from one SQL … Continue reading

Posted in Database options, Disaster Recovery, SQL Server, T-SQL | Tagged , , | 3 Comments

Restore database permissions

Introduction: I came across a couple of subtle gotchas around the permissions required to restore a database in SQL Server 2008+ recently. I’m interested in situations where a DBA needs to allow certain users the ability to restore a given … Continue reading

Posted in Database options, Disaster Recovery, Security, SQL Server, T-SQL | Tagged , , | 14 Comments

Migrating SQL Server Databases that use Database Master Keys

There’s a lot of things to consider when migrating databases between SQL Server instances. I want to provide some tips for dealing with Database Master Keys, and in particular the case when those keys are encrypted by the Service Master … Continue reading

Posted in Database options, Disaster Recovery, Security, SQL Server, T-SQL | Tagged , , | 29 Comments

Restores in SQL Server Analysis Services

“You’re only as good as your last restore” I’ve no idea who originally said that – but it probably qualifies as DBA folklore. I blogged recently about backups in SSAS so to close the loop here are the basics of … Continue reading

Posted in Disaster Recovery, SSAS | 1 Comment

Backups in SQL Server Analysis Services

Analysis Services databases should be backed up at regular intervals like any other database. Here are the basics. Using the GUI: Connect to the SSAS service in SQL Server management studio. Right click on the database and select backup. The … Continue reading

Posted in Disaster Recovery, SSAS | 1 Comment

Corrupt Model database

An interesting case arose at work the other day. SAN issues had caused SQL Server to shutdown and it was unable to be restarted because the data files were unavailable. Once the SAN was back online the instance still could … Continue reading

Posted in Disaster Recovery, SQL Server | 1 Comment

Locked out of SQL Server.

This is a very cool and useful tip if you find yourself locked out of the sysadmin role in sql server. I have a SQL Server instance with the sa account disabled and all other logins removed to simulate a … Continue reading

Posted in Disaster Recovery, Security, SQL Server | Tagged | 3 Comments