Hi
i have searched and also use this tech note for my SQL server troublehooting
this is KB Article and very hidden article by symantec but its very useful for the users taking Backups of SQL Databases
So just for easiness of users i am publishing it, will help all SQL users who are backing thier data bases through Netbackup
Article:TECH38369 | | | Created: 2005-01-13 | | | Updated: 2012-09-10 | | |
Article URL http://www.symantec.com/docs/TECH38369
|
How to troubleshoot Microsoft SQL Server database backup issues
Troubleshooting all NetBackup issues requires a certain knowledge of the servers involved with the backup or restore. At a minimum, the following information should be known:
For database backups and restores, knowledge of the version of the database as well as any patches is also necessary.
To determine the version of the SQL server, open SQL query analyzer, and run the following query:
select @@version
Review the output and compare it to the information in Microsoft Q321185
http://support.microsoft.com/default.aspx?scid=kb;en-us;321185
Since SQL backups and restores do not use the bpbkar process, it is necessary to enable different logging than for flat file backup. For SQL backups and restores, enable the dbclient log file by creating a folder called dbclient in the <install_path>\veritas\netbackup\logs directory. Additionally, it is helpful to review the progress log file from the backup or restore (<install_path>\veritas\netbackup\logs\user_ops\mssql\logs) and have access to the SQL error logs, the VDI log, and the Microsoft Application Event Viewer log file.
In addition, there are two Windows services which must be running to correctly configure the NetBackup MS SQL GUI. They are the Protected Storage and Remote Registry Service. Confirm these services are running if there are difficulties configuring the NetBackup SQL GUI.
Most SQL backups fail with a Status 2, none of the requested files were backed up. Here are some possible causes of this failure:
- For SQL backups to run from the master server, the NetBackup Client Service needs to be started as an account with specific rights. For more information on SQL permissions, please review the following Technote:
- Confirm the SQL databases can be seen in the NetBackup MS SQL Client. If not, the user set in the NBU SQL GUI for backup and restores is not an administrator. From the Options menu, select Set DBMS login parameters, and enter an administrator ID and password. Review the following Technote for required permission information:
- After confirming the database appears in the GUI, attempt a backup of a test database from the client GUI. From the Actions menu, select backup, and do an immediate backup of a small database (such as Model). If this fails, review the dbclient log files for errors.
- If backups from the client are successful, delete and recreate the batch file (.bch) being used for backups. Do not attempt to overwrite any existing batch files, as saving a batch file to the same name as an existing batch file appends any newly specified operations to the existing batch file. From Actions > Backup, select the names of the databases for backup on the right side of the window, and then select "Save for later execution". After clicking on the OK button, enter a name for the batch file, and save the script. It is not necessary to open this script if prompted. Note, if the script is saved in the default location (<install_path>\veritas\netbackup\dbext\mssql), only the name of the batch file needs to be entered in the SQL policy "Backup Selections" tab. If the batch file is placed in a location other than the default, the entire path name and the name of the batch file needs to be entered in the "Backup Selections" tab.
- If none of this applies, collect the following information and log files, and contact NetBackup Technical Support:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.