SQL High Availability

Standby Server:

Created at time of primary server and had the same DB that is created by a backup restore process on the primary server.  The restore is done with a NORECOVERY OPTION or with a STANDBY option.

The STANDBY option allows you to maintain the database in a read only role as NORECOVERY does not.

(Great for reporting needs.)

Mechanism

Periodically regular transaction log backups are performed on the primary server then restored to the standby server with the NO RECOVERY option which leaves the primary server in recovery mode so it can later have the standby server logs applied to it.

Upon failure of the primary server:

• All unapplied transaction logs must be applied.

• The active log file needs to be backed up with the NORECOVERY backup option.

• The name of the standby server must be renamed to that of the primary server

• All uncommitted transactions must be restarted

• Before bringing online user logins must be recreated, scripted, or created using the DTS Transfer Logins Task. (SQL 2000)

Next Set->