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.
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.