Using NetBackup for SQL Server with database mirroring Impact on recovery
may notice that the NetBackup for SQL Server progress log for the inhibited operation specifies a message similar to the following:
Database ACCOUNTING SUN. This operation
is in a must be
SQL Server instance Server instance MOON.
Impact on recovery
When you restore a mirrored database, you must run the NetBackup MS SQL Client from the host that contains the mirroring partner that is in the principal role. See SQL Server 2005 Books Online for information on how to determine which partner is the principal.
Backup images may have been created on either or both of the mirroring partners. However, they are displayed as a unified tree view in the Restore Database dialog box irrespective of the partner from which they had been backed up. In addition, the recovery script created for the database is created from images from both partners as appropriate. To determine which partner the backup was taken from, look at the property page for the image.
To view backup images you may look on the hosts that contains either of the mirroring partners, provided that backups were done for that partner. For example, suppose that mirroring partners are as follows:
SQL Server instance
Moreover, suppose that all of the backups were done on HostB, though the principal is currently on HostA. To browse backup images, for the Accounting database, take the following steps:
To browse for backup images
On HostA, open the NetBackup MS SQL Client.
From the File menu, choose Restore SQL Server Objects.
In the Backup History Options dialog box, select HostB in the SQL Host