Search
Home
Articles
Backup
Books
Certification
FAQ
Products
Replication
Scripts
Seminars
Training
TSQL
MSDN Fourms
Philippine SSUG
Fort Worth SSUG
Oklahoma City SSDG
Resume
MHS Enterprises
BlowFrog Software
FilAm Software
AcrylicAcetate.com
Bargain Humidors
Western Humidor

6.5 Disaster Recovery Plan 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

Swap the arrays from the failed server into the cold standby server

Note: When you move drives from one machine to another, you must ensure that the drives go into the same bus and slot as they were on the original system. I have only seen this tested on Compaq equipment and can not verify if it will work on another manufacturer’s equipment.

  1. Remove the system drives from the failed server and insert into the cold standby.
  2. Remove the drives from the failed server and insert them into the internal or external storage cabinet on the cold standby server. Ensure that you are inserting the drives into the same bus and slot as they resided in on the failed server.
  3. Once all drives are moved, power up the cold standby
  4. Press F10 as soon as it is available during the initial boot.
  5. Follow the prompts to update the hardware configuration.
  6. Once Windows NT starts up, remove the NIC
  7. Reboot the server
  8. After Windows NT restarts, add in the appropriate NIC
  9. Reboot the server
  10. After Windows NT restarts, apply the SSD to update the video and network drivers
  11. Reboot the server
  12. After Windows NT restarts, run the Compaq array configuration utility.
  13. Select cancel when the wizard starts
  14. Configure the arrays exactly the way they were in the failed server
  15. Follow the rest of the prompts and exit the array configuration utility
  16. Start up Disk Administrator
  17. Specify drive letters for the partitions as they were on the failed server
  18. Reboot the server
  19. After Windows NT restarts, ensure that all services have started properly
  20. Verify that all databases have completed recovery
  21. Make sure that you can select data from a few random tables to ensure access
  22. If replication is installed, reset replication
  23. Place the server into production

Restore an image of the server from the Backup Server to the cold standby

  1. Power up the cold standby
  2. Verify a connection to the Backup Server
  3. Using the Enterprise backup solution, restore the last image on to the cold standby.
  4. If replication is installed, reset replication
  5. If the last image is bad, proceed to option 5

 

6.5 Disaster Recovery Plan 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

Michael R. Hotek

All content on this site, except where noted, represents an original work of Michael R. Hotek and is protected by applicable copyright laws. The SQL Server FAQ is the sole work of Neil Pike. No page, portion of a page, or download may be used for commercial purposes in whole or in part without the express, written permission of the applicable author.