Initialize Warm Standby

Microsoft SQL Server Virtual Backup

Microsoft SQL Server Virtual Backup Device Specification

Initialize Warm Standby

The snapshot is used to initialize the secondary database on the standby server. Once initialized, the standby database will be maintained in the usual manner via log shipping.

Steps

  • Restore the database with norecovery or standby.

  • Maintain database via log shipping.