When a Windows SQL Server database is faulty, you can restore files in the database using backup images.

Prerequisites

• The SQL Server master database is intact, and the SQL Server can be started correctly.
• The full virtual machine has been backed up at least once.

Context

Procedure

1. Log in as user Administrator to the virtual machine.
2. Choose Start > All Programs > Symantec NetBackup > NetBackup Agents > NetBackup MS SQL Client.
The NetBackup Database Extension - Graphical User Interface page is displayed.
3. Browse to find SQL Server backup images.
1. Choose File > Restore SQL Server Objects.
The Backup History Options dialog box is displayed.
2. Select the SQL host whose backup images you want to browse. Select the date range.
• Select or enter the name of the virtual machine host in SQL Host.
• In Source Client, keep the default value or type the source client name. Keep the default value same as SQL Host as an example.
• In the Time filter area, set the start and end dates of browsing for backup images.
3. Click OK.
The Restore Microsoft SQL Server Object dialog box is displayed.
4. Click the plus sign (+) to expand the instance and database to be recovered.
4. Select the VMware backup image of the database that you want to recover.
indicates the VMware backup image of a database.
5. In the Restore options area, set Scripting to Restore selected object. Click Restore.
The NetBackup Database Extension dialog box is displayed.
6. Click Yes to start the restore.
The NetBackup Database Extension dialog box is displayed indicating that the SQL Server database is being recovered.
7. Click OK.