V11 SP8
Loading...

Restore to a Hot Standby SQL Server

You can keep the latest copy of the production database on a hot standby server. A hot standby server is always kept in a near-ready state by backing up the latest backup copy of the production database to the standby server periodically.

If a database on the production server fails, you need not wait to restore the whole database from the failed server. You can minimize the downtime by applying the latest backup to a standby server and then bringing the database online on the standby server.

You can follow these tasks in the given sequence to restore the latest copy of the production database on a hot standby server:

  1. Setting Up a Hot Standby Server
  2. Bringing the Hot Standby Server Online
  3. Restoring SQL Transaction Logs to a Hot Standby Server