NetBackup™ for Microsoft SQL Server Administrator's Guide
- About NetBackup for SQL Server
- Installation
- Host configuration and job settings
- Installing the Veritas VSS provider for vSphere
- Configuring RBAC for SQL Server administrators
- Managing SQL Server assets and their credentials
- About discovery of SQL Server objects
- About registering SQL Server instances and availability replicas
- Configuring backups with SQL Server Intelligent Policy
- Performance tuning and configuration options
- Protecting SQL Server availability groups
- Protecting SQL Server availability groups with intelligent policies
- Protecting SQL Server availibility groups with batch file-based policies
- About protecting the preferred replica in a SQL Server availability group (batch file-based policies)
- About protecting a specific node in a SQL Server availability group (batch file-based policies)
- About protecting the preferred replica in a SQL Server availability group (batch file-based policies)
- Protecting SQL Server with VMware backups
- About protecting an application database with VMware backups
- Create a protection plan to protect SQL Server data with a VMware backup
- Configuring backup policies with Snapshot Client
- Using copy-only snapshot backups to affect how differentials are based
- About SQL Server agent grouped snapshots
- Protecting SQL Server in a cluster environment
- Managing protection plans for SQL Server
- Restoring SQL Server with the NetBackup web UI
- Using instant access with SQL Server
- Prerequisites when you configure an instant access SQL Server database
- Configuring batch-file based policies for SQL Server backups
- Requirements to use batch files with NetBackup for SQL Server
- Schedule properties for SQL Server batch file-based policies
- Configure a batch file-based policy for a user-directed backup of read-only filegroups
- Performing backups and restores with the NetBackup MS SQL Client
- Redirect a SQL Server database to a different host (NetBackup MS SQL Client)
- Restoring multistreamed SQL Server backups
- Using NetBackup for SQL Server with multiple NICs
- Performance and troubleshooting
- About debug logging for SQL Server troubleshooting
- About disaster recovery of SQL Server
- Appendix A. Other configurations
- About SQL Server backups and restores in an SAP environment
- About NetBackup for SQL Server with database mirroring
- Appendix B. Register authorized locations
Veritas VSS provider logs
The Veritas VSS provider records its activities in Windows Event Logs. Debug logs are also available at the following location:
install_path\Veritas VSS provider\logs
Enable the Veritas VSS provider logging on the NetBackup computer where SQL Server is installed.
To enable Veritas VSS provider logging in the registry
- Log on as administrator on the computer where NetBackup is installed.
- Open Regedit.
- Open the following key:
HKEY_LOCAL_MACHINE\SOFTWARE\Veritas\NetBackup\CurrentVersion\Config
- Create a new DWORD value named CreateDebugLog.
- Right-click on the new value and click Modify.
- In the Value data box, enter 1.
- Click OK.
To increase the log debug level modify both the pre-freeze-script.bat and post-thaw-script.bat files in the C:\Windows
folder. Add the -log
parameter to the script, at the line where BeVssRequestor.exe
is called. VMware determines which script is invoked.
To increase the Veritas VSS provider log debug level
- Change the following line in the pre-freeze-script.bat:
BeVssRequestor.exe -pre2 -logscreen !SkipExReplica! !SkipSQL! !VMBackupType! !ExcludeList!
to:
BeVssRequestor.exe -pre2 -logscreen !SkipExReplica! !SkipSQL! !VMBackupType! !ExcludeList! -log
- Also change the following line in the post-thaw-script.bat:
BeVssRequestor.exe -post2 -logscreen !SkipExReplica! !SkipSQL! !VMBackupType! !ExcludeList!
to:
BeVssRequestor.exe -post2 -logscreen !SkipExReplica! !SkipSQL! !VMBackupType! !ExcludeList! -log