Where Do I Start With A Run Book?

(Originally posted on my personal blog.)

On SuperUser.com, a question came up about how to do a proper Linux backup, including the applications installed, and associated configurations. In light of a previous post I wrote about backups and run books, I thought this would be useful information to share.

I answered with a link to the original run book I have used, from Microsoft’s own TechNet site. Though it deals specifically with SQL Server 2000 and high availability, the content of the article is more than enough for anyone to create their own run book:

A run book should contain all of the information you and your staff need to perform day-to-day operations and to respond to emergency situations. This information should include the following:

  • Resource information about the data center and its hardware and software
  • Process information, including step-by-step procedures for operational and emergency processes

The run book should contain all necessary information to enable a staff member to perform any process, from performing a backup to failing over to a remote site.

Following on from this post, Jes Schultz Borland has written a great post about documentation on Brent Ozar Unlimited, which includes a sample Excel workbook as a basis for a run book. The post also goes into detail about how to fill it in.

Check it out.

Author: randolph

Randolph West is a Microsoft Data Platform MVP, and has worked with SQL Server since the late 1990s. When not consulting, he can be seen acting on the stage and screen, or doing voices for independent video games. Randolph is available for talks on SQL Server, and technology in general. He also offers training for junior DBAs. Connect with Randolph on Google+ or Twitter.