Search <book_title>...

NetBackup™ for Microsoft SQL Server Administrator's Guide

Last Published: 2022-09-08

Product(s): NetBackup & Alta Data Protection (10.1)

Restoring a mirrored database backup image

Note:

Before you restore a mirrored database, you must remove the mirroring attribute.

For mirrored databases, NetBackup can create backup images on either or on both the principal and the mirror server. The Restore Database dialog box displays any backups images from both servers. To determine which partner the backup was taken from, look at the property page for the image. To view backup images you can select the Host name that contains either of the mirroring partners, provided that NetBackup performed backups for that partner.

For example, assume that mirroring partners are as follows. All of the backups were done on HostB, though the principal is currently on HostA:

Principal
Host name: HostA
SQL Server instance: Solaria
Database: Accounting
Mirror
Host name: HostB
SQL Server instance: Moonbeam
Database: Accounting

If backup images were created exclusively on HostA or on both HostA and HostB, you can view the images from both partners. Select HostA in the SQL Host list.

To restore a mirrored backup image

Disable mirroring on the principal mirror.
You can use the appropriate commands in SQL Server Management Studio or use ALTER DATABASE directly.
On the principal server, open the NetBackup MS SQL Client.
When you restore a mirror database, you must run the NetBackup MS SQL Client from the principal server. See SQL Server Books Online for information on how to determine which partner is the principal.
In the previous example, the principal is HostA.
On the File menu, select Restore SQL Server Objects.
In the Backup History Options dialog box, from the SQL host list select the mirror server.
In the previous example, the mirror is HostB.
Click OK.
Proceed with the restore as normal.
NetBackup creates a recovery script for the database that includes images from both partners, as appropriate.