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: