X hits on this document

517 views

0 shares

0 downloads

0 comments

173 / 200

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

mirroring performed

role on

on

SQL

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:

Principal

Host name

HostA

SQL Server instance

Solaria

Database

Accounti

Mirror

HostB

ng

Moonbeam

Accounting

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

  • 1.

    On HostA, open the NetBackup MS SQL Client.

  • 2.

    From the File menu, choose Restore SQL Server Objects.

  • 3.

    In the Backup History Options dialog box, select HostB in the SQL Host

dropdown.

4.

Click OK.

173

Document info
Document views517
Page views517
Page last viewedThu Dec 08 15:19:46 UTC 2016
Pages200
Paragraphs4189
Words49499

Comments