SQL Server - Restore to a Hot Standby Server

You can keep the latest copy of the production database on a hot standby server. Keep a hot standby server in a near-ready state by periodically restoring the latest backup of the production database to the standby server.

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

Loading...