X hits on this document

486 views

0 shares

0 downloads

0 comments

172 / 200

Using NetBackup for SQL Server with database mirroring Impact on backup

2

Any policy used to back up the principal should also specify the host that contains the mirror database.

3

Permission for a redirected restore must be established between both mirroring partners.

To establish redirected restore permission between two hosts

On the master server, create a file called: install_path\NetBackup\db\altnames\No.Restrictions

OR

Create each of the files on the master server: install_path\NetBackup\db\altnames\hostA install_path\NetBackup\db\altnames\hostB

172

Note: When you create the No.Restrictions file it allows all clients to perform redirected restores to different clients. This file may need to be added and removed according to your site policies.

Impact on backup

Since backups can occur only on the principal, you must take steps to ensure that you don't miss any scheduled backups due to failover. Establish a procedure to simultaneously initiate backups for both partners, but suppress the operation on the mirror.

To achieve this objective, first create a backup schedule for the principal. See “Configuring a backup policy for a database” on page 26. Then take the following steps:

To simultaneously initiate backups for both partners

1

Add the host containing the mirroring partner to the client list of the policy that you created for the principal.

2

Create a batch file on the mirroring partner that has the same name as the batch file specified in the backup selections policy.

The batch file on the mirroring partner should be identical to the one used on the principal except that the value supplied for SQLHOST and SQLINSTANCE are different.

When you follow these steps, it ensures that any scheduled backup for a mirrored database is launched on both the principal and the mirror. The backup on the principal should run normally. The backup on the mirror is inhibited. You

Document info
Document views486
Page views486
Page last viewedWed Dec 07 13:13:58 UTC 2016
Pages200
Paragraphs4189
Words49499

Comments