Replication Using Warm Database Restore
Using the SQL Server Database(s) on the Hot Standby Server
Performing Disaster Recovery Operations for the Primary SQL Server Database(s)
This type of restore is also called Hot Server Restore. You can keep up-to-date copies of the production databases on alternate servers, thus minimizing down time in cases where the production database server has failed.
The advantages of Warm Database Restore over a traditional restore scenario is that the database is always kept in a near ready state. In the case of disaster, users do not need to wait for the time it would take to restore the database in its entirety. Only the latest backup may need to be applied to the target database before turning the application over to use it.
Review the following requirements before performing a Warm Database Restore:
Use the following steps to setup the standby server:
If you do not select the Apply Log Backups Only option and the database already exists, all backup jobs completed since the last restore operation will automatically be restored.
If you do not select the Apply Log Backups Only option and the database does not already exist, the software will automatically perform a full restore of the database.If the entire primary server is lost, you must perform a full system restore.
Once the full system restore has completed, you will need to set up the hot standby server again by repeating the steps outlined in this procedure. |