Category: SQL Server

How to Gain Emergency Sysadmin rights to a SQL Server

Whether you are trying to find the purpose of a SQL Server you just became responsible for, or access has been accidentally dropped, or you need to administer a vendor installed SQL instance, or a host of other reasons, from time to time you will need to get emergency sysadmin access into a SQL Server. This post talks about your options for regaining access to that rogue server.

Read More →

Are Backups Valid DR?

The below is an extract from my presentation at SQL Saturday 252 on high availability and disaster recovery. In this section we talk about the basic process of backing up databases and whether this is enough to meet your requirements.

Read More →