Other applications of NetBackup for SQL Server Using NetBackup to restore SQL Server from Backup Exec images
Restore options on the Microsoft SQL Server tab (continued)
Leave database operational. No additional transaction logs can be restored.
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.
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.