X hits on this document

427 views

0 shares

0 downloads

0 comments

126 / 200

126

Using NetBackup for SQL Server with clustering solutions Performing a backup on a virtual SQL Server instance

Performing a backup on a virtual SQL Server instance

Although NetBackup for SQL Server supports browsing for databases and images on any of the physical nodes, a user backup or restore will not be successful unless it is launched from the NetBackup client that is active. After NetBackup has been configured as described in the previous sections, backing up a SQL Server database from a virtual instance is similar to backing up a database from a non-virtual one.

To perform a backup on a virtual SQL Server instance

1 2 3 4

Open the NetBackup for SQL Server interface on the active platform node. Choose File > Backup SQL Server objects. Select one or more databases. In the NetBackup Policy field, enter the name of the MS-SQL Server policy

(VIRTSQLPOLICY) that was created for specifying storage attributes for the virtual SQL Server backup.

5

Click OK.

Performing a restore on a virtual SQL Server instance

To perform a restore on a virtual SQL Server instance

1 2 3

Open the NetBackup for SQL Server interface on the active platform node. Choose File > Restore SQL Server objects. In the Backup History Options dialog box, from the SQL Host list, select the

4 5 6

Virtual Server name (VIRTUALSERVER) as the SQL host. From the SQL Server Instance drop-down list, choose <default>. Click OK.

In the Restore Microsoft SQL Server Objects dialog box, select a backup image or staged image list.

7

Click OK.

Document info
Document views427
Page views427
Page last viewedSun Dec 04 12:52:54 UTC 2016
Pages200
Paragraphs4189
Words49499

Comments