Managing a Backup Server

If a hard disk drive or other failure results in the computer being unusable for a while, it can be a relief to know you have reliable backups of your data. However, making the necessary repairs and reloading the dumps of the database and logs can take considerable time. A very cost-effective alternative to this is to maintain a "warm" backup server at all times.

SQL Server includes features that make it very easy to have another server standing by in case something should happen to the primary production server. Assume that you have two servers:

Each time a database is dumped from Primary, you will immediately load it onto Standby. Likewise, you will immediately load each transaction log dump from Primary onto Standby. It is recommended, as an additional precaution, that these dumps also be copied to tape or some other medium and stored. Should a problem arise on Primary that will require significant downtime, Primary can be taken offline, and Standby's server name changed to Primary. Using this approach, the only downtime will be the few minutes necessary to take Primary offline and change Standby's name. No user applications will need to change, and the data on the server will be current through the last transaction log dump made from the old Primary server.