X hits on this document





157 / 200

Other applications of NetBackup for SQL Server Using NetBackup to restore SQL Server from Backup Exec images

Table 9-14

Restore options on the Microsoft SQL Server tab (continued)



Leave database operational. No additional transaction logs can be restored.

(With Recovery)

Select this option when restoring the last database, differential, or log backup in the restore sequence in order to have the restore operation roll back all uncompleted transactions. After the recovery operation, the database is ready for use. If Leave database operational is not performed, the database is left in an intermediate state and is not usable.

If Leave database operational is selected when an intermediate backup is being applied, you cannot continue to restore backups.

You must restart the restore operation from the beginning.

Leave database nonoperational but able to restore additional transaction logs

Select this option during a restore if you have additional differential or transaction log backups to be restored in another restore job.

(No Recovery)

Leave database read-only and able to restore additional transaction logs

Select this option during transaction log and database restore to create and maintain a standby database. See your SQL documentation for information on standby databases.


Replace databases or filegroups

Select this checkbox to replace a database or filegroup, even if another database or filegroup with the same name already exists on the server. If Replace Databases or Filegroups is not specified for a restore, SQL performs a safety check to ensure that a different database or filegroup is not accidentally overwritten. Refer to your SQL documentation for more information about the safety check that occurs when the REPLACE option is not selected.

Automate master database restore

Enable NetBackup to stop SQL so that the master database can be restored. All existing users are logged off, and SQL Server is put into single-user mode.

When this option is selected, only the master database can be restored; if this option is selected for any other database, those jobs will fail.

If NetBackup does not have access to the SQL registry keys, HKEY_LOCAL_MACHINE\Software\Microsoft\ Microsoft SQL Server, and HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer, then a restore to the default directory may not work, and the option Automate master database restore will not work. To ensure that NetBackup has access rights, verify that the user account of the NetBackup Client Service has administrator rights to the Windows server that the SQL instance is installed on.


Document info
Document views615
Page views615
Page last viewedWed Jan 18 09:58:49 UTC 2017