This article will show you one way to quickly restore SQL Server replication with huge tables.  Read more...

An outage at SQLServerCentral reminded Steve Jones that it's not "if" a disaster will occur, but "when" it will occur that should have you preparing for a disaster at some point in the future.  Read more...

This white paper discusses how to reduce planned and unplanned downtime, maximize application availability, and provide data protection using SQL Server 2012 AlwaysOn high availability and disaster recovery solutions.  Read more...

In this article we will see how to rebuild system databases in SQL Server 2008 cluster that is failed to restart.   Read more...

This article shows you the process which you require to regain your sysadmin access.  Read more...

This article describes the requirements to log ship databases between workgroup computers  Read more...

This editorial was originally published on Feb 5, 2007 and is being re-run as Steve is on vacation. Is this the advice you'd give, or take, in a DR situation? Steve thinks it's not.  Read more...

This article covers how to use robocopy with SQL Server Agent to copy database backup files to another server.  Read more...

Planning for disaster recovery entails a lot of different items, but testing is an important one. If you don't test your plans, you can't be sure they will work. This Friday Steve Jones asks how often your test.  Read more...

We had a requirement where we were asked to generate automatic email notification in the event of a failover.   Read more...

Author Craig Outcalt gives advice on preparing for the worst with a look at what you should consider putting in your disaster recovery plan and why.  Read more...

This is a real-time production issue I faced with one of our clients  Read more...

Do you plan for failure as a possibility or a probability? The difference might mean you take your plans and testing a little more seriously. Steve Jones notes that you might want to plan on the latter.  Read more...

Functionality to help maintain a Disaster/Recovery (D/R) Environment synchronized with production is introduced and the associated challenges are discussed.  Read more...

How to rebuild your master database quickly and safely.  Read more...

Multi-subnet Failover Clusters I want to take a closer look at one of the new features in SQL Server Denali. While...  Read more...

This Friday Steve Jones has a DR poll. He asks what might be more important to you in a disaster and why.  Read more...

I have installed and uninstalled several instances of SQL Server in the past. Today, I need to uninstall a SQL Server 2008 R2 clustered instance. I have never uninstalled a clustered instance of SQL Server before. Can you provide a how-to guide to uninstall a clustered instance of SQL Server 2008 R2?  Read more...

Today we have a guest editorial from Andy Warren. Andy discusses the need to consider personnel when you are planning for things to go wrong.  Read more...

I'm needing to audit the permissions in my databases, but I want to script them out so I have something to run in case of a recovery situation. I've got the logins, roles, and users handled, but it's the permissions that I want to extract. How can I do this easily?  Read more...