One of the important things is to be able to recover your environment. That doesn't mean you need to know everything about SQL Server and potential disasters, but you should know their affect on your situation.  Read more...

Minor disasters can become major ones quickly.  Read more...

Preparing a disaster recovery plan means more than just trying to prevent a few specific disasters. It means turning around the way you view the world.  Read more...

In the first in a series on the practicalities of using the Microsoft Azure Platform for the SQL Server professional, Buck Woody shows that, whatever your version of SQL Server, there is a way of storing offsite backups in the cloud.  Read more...

Ask database administrators how they implement disaster recovery in their big data environments and you'll get two typical responses: DR plans are not necessary and backups take up a lot of space. Despite this reasoning, a disaster recovery plan for your big data implementation may be essential for your company's future.  Read more...

SQL Server 2012 AlwaysOn provides flexible design choices for selecting an appropriate high availability and disaster recovery solution for your application. This article looks at the common design patterns.  Read more...

Using Log Shipping? Looking for a more automated way to fail over during a disaster? Read on...  Read more...

Dave Lumley presents a Reporting services disaster recovery solution for SQL Server Standard Edition, using 2 servers. Worth the read if you don't run Enterprise.  Read more...

Are tape systems obsolete? A recent incident has Steve Jones thinking perhaps not.  Read more...

Dealing with a disaster is a trying experience for anyone, but having to then worry about having the proper software installed can make things much worse. Steve Jones talks a bit about the challenges of worrying about software versions.  Read more...

This script will store all index definitions into a table that you can use to "re-create" the indexes at a later date.  Read more...

Years ago I worked at an ISO certified organization, where we took our administration and planning seriously. We ensured everything...  Read more...

A corollary to Murphy's Law states that disaster is most likely to strike when your senior people are out of the office.  Read more...

Today's complex systems are too large to be able to rely on any DBA's memory for knowledge of each component, and its configuration options and settings.   Read more...

Our next webinar on July 23rd has Steve Jones presenting on some disaster stories with ideas on how you might prevent, or mitigate the effects, of those problem situations.  Read more...

Sometimes recovery simply entails rerunning a failed process.  Read more...

Our next webinar on July 23rd has Steve Jones presenting on some disaster stories with ideas on how you might prevent, or mitigate the effects, of those problem situations.  Read more...

Read more...

Our next webinar on July 23rd has Steve Jones presenting on some disaster stories with ideas on how you might prevent, or mitigate the effects, of those problem situations.  Read more...

Freshly minted MCM Wayne Sheffield fills a log shipping crack that could otherwise cause you to re-initialize your log shipping.  Read more...