Category Archives: Disaster Recovery

The most recent backup problem

Posted on February 3, 2015 by

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

Posted on November 6, 2014 by

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.

Posted on October 7, 2014 by

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.

Posted on March 27, 2014 by

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

Posted on January 10, 2013 by

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

Posted on November 13, 2012 by

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 , , | 30 Comments

Restores in SQL Server Analysis Services

Posted on August 1, 2012 by

“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

Posted on July 19, 2012 by

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

Posted on June 20, 2012 by

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.

Posted on April 30, 2012 by

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