Veritas NetBackup™ for Microsoft SQL Server Administrator's Guide
- Introducing NetBackup for SQL Server
- Installation and host configuration
- Host configuration and job settings
- Managing SQL Server objects for use with SQL Server Intelligent Policies
- About discovery of SQL Server objects
- About registering SQL Server instances and availability replicas
- Registering instances or availability replicas with an instance group
- Configuring backups with SQL Server Intelligent Policy
- About tuning parameters for SQL Server backups
- Performing restores of SQL Server
- Redirecting a SQL Server database to a different host
- Protecting SQL Server data with VMware backups
- About protecting an application database with VMware backups
- Configuring backups with Snapshot Client
- Using copy-only snapshot backups to affect how differentials are based
- About SQL Server agent grouped backups (legacy SQL Server policies)
- Protecting SQL Server availability groups
- Protecting SQL Server availability groups with intelligent policies
- Protecting SQL Server availibility groups with legacy policies
- About protecting the preferred replica in a SQL Server availability group (legacy backup policies)
- About protecting a specific node in a SQL Server availability group (legacy backup policies)
- About protecting the preferred replica in a SQL Server availability group (legacy backup policies)
- Protecting SQL Server in a cluster environment
- Configuring backups with legacy SQL Server policies using clients and batch files
- About using batch files with NetBackup for SQL Server
- About schedule properties
- Performing user-directed backups of SQL Server databases
- Performing user-directed backups of read-only filegroups
- 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
- 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