Disaster Recovery (DR)

SQLServerCentral Article

Incident Response - The Framework

  • Article

Do you have a SQL Server disaster plan? What about something less than a disaster? Steve Jones has worked more than his share of disasters or incidents, some of them self-inflicted. He's taken some of his experience and started a new series looking at a framework for dealing with incidents. Read part 1 about getting prepared.


6,367 reads

SQLServerCentral Article

Backup Scenarios for successful SQL Server Restores and Recovery

  • Article

SQL Server has a great backup and recovery architecture, but you have to know how to properly configure and use the server to ensure that you will not be seeking new employment anytime soon. A few of the Sonasoft team have written this short piece on strategies for setting up your backup jobs to ensure recovery in the event of a disaster. Welcome new authors Bilal Ahmed, Kiran Kumar, and Vas Srinivasan.

4 (2)


18,742 reads

SQLServerCentral Article

Save Yourself - Recovering from an XP Disaster

  • Article

How many of you dig into Windows XP extensively? Working with hardware and the OS isn't something that many DBAs deal with these days. Most companies have an admin to work on servers, hardware, workstations, etc. But sometimes you need to help yourself out. Steve Jones had to work to get his laptop back after an XP disaster. Read on and hopefully this will help you one day recover your system.


5,883 reads

SQLServerCentral Article

Mini Disaster - AC Failure

  • Article

Are you prepared to handle a full or partial failure of your AC system? Ever thought about what would happen if it did happen. Once again Andy offers comments on a real world incident. While we'd all like to think it will never happen to us, we think sharing these incidents is a great way to prevent it from happening to others.


6,126 reads


Registered for the Data Community Summit


I was reminded this week that I needed to get registered for the Data...

Daily Coping 5 Oct 2022


Today’s coping tip is to choose to see your mistakes as steps to help...



Good day reader.  This post is coming to you from a busy week in...

Read the latest Blogs


Change tracking - Date a row changed

By cbarus

We have change tracking enabled on one of our databases and I am looking...

Grant user permissions to a view but the base tables live in another database

By Maxer

I have two databases on the same server.  I have a service account I...

The ORDER BY clause is invalid in views

By micky007

Hi, I'm trying to run the below SQL code but I'm getting this error:...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers