Disaster Recovery (DR)

SQLServerCentral Article

The DBA Whoops

  • Article

Ever do something to your SQL Server 2000 server and then realize you've just broken something major? Ever have a moment when you want to go "whoops", but really feel like crying ot running away? Steve Jones just had one of those and gives you a few things to think about when you deal with a situation like that.

5 (1)


12,019 reads

External Article

Why bother with backup?

  • Article

Backing up SQL Server data is like many of the things we do because we figure we need to. It is good for you, like eating a good diet and getting exercise. Unfortunately, folks are often about as successful with SQL Server backups as they are with diet and exercise.

This is the first in a series of articles covering SQL Server database backup. The series starts from the very basics of why database backup is important. The question of why to backup a database can inform many other decisions.


2,411 reads

SQLServerCentral Article

Worst Practice - Detailed Disaster Plans

  • Article

Another in our series of things you should avoid at all costs. Seems silly at first, not having a detailed recovery plan for your SQL Server. Perhaps it is, but having dealt with any number of problems over the last few years, Steve Jones has some ideas why a detailed plan may not be the best thing to spend your time on.


8,007 reads




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

DevOps From Redgate


In a few weeks at the PASS Data Community Summit, I’ll be joining several...

Daily Coping 4 Oct


Today’s coping tip is to free up time by canceling any unnecessary plans. I....

Read the latest Blogs


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:...

SQL Server Windows NT - 64 bit" in Task Manager: CPU high

By EL-wakil

  Hello ,   The SQL Server Windows NT - 64 bit" in Task...

Shutdown without NOWAIT

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Shutdown without NOWAIT

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers