07-04-2011 04:10 AM
How to configure veritas NetBackup for backups and restores of Microsoft SQL server
07-04-2011 04:50 AM
NetBackup versions?
As a start:
Symantec NetBackup for Microsoft SQL Server 7.1 Administrator’s Guide
http://www.symantec.com/business/support/index?page=content&id=DOC3670
Symantec NetBackup (tm) 7.0 for Microsoft SQL Server Administrator's Guide
http://www.symantec.com/business/support/index?page=content&id=TECH127055
Veritas NetBackup (tm) 6.5 for Microsoft SQL Server Administrator's Guide
http://www.symantec.com/business/support/index?page=content&id=TECH52812
07-04-2011 05:28 AM
Hi,
If the manual is hard to follow, here is what you can do.
Install the netabackup client software on the sql server and open the Netbackup MSSQL Database gui on the sql server and put in the sqlhost and go to File, Backup ......., select the All option and save the file. That will add DATABASE ALL to the batch script and will backup all the databases.
Change the netbackup client service on the sql server to run in a local admin account with sysadmin rights in sql studio manager.
Create a sql policy on the master server and all the whole path to the sql batch script you saved in the Netbackup MSSQL database gui. Create a full backup schedule in the sql policy and configure backup window, keep the Default Application Backup open 24/7
Try to kick off the backup and hopefully will it be successful.
You have to start the restore from the sql server, open the Netbackup MSSQL Database gui and to to File, Restore...., put in the correct sql host name and date frame. Select the database you want to restore and launch immediately to restore. If you want to redirect, you can select to Create move template and edit the script. Remove hash sign before database and change the database name to something else if you want to redirect to another database and remove hash sign before to and change the path to where you want to restore the .mdb and .ldf file.
Create following log directories to troubleshoot any problems for backup and restore.
<install dir>\netbackup\logs\bpcd
<install dir>\netbackup\logs\bphdb
<install dir>\netbackup\logs\dbclient
I hope this helps.
/Oddy
09-26-2011 04:19 AM
May be this tuturial video could help:
http://www.symantec.com/connect/videos/netbackup7-ms-sql-backups
Regards
09-26-2011 05:48 AM
Please try this.....
http://www.symantec.com/business/support/index?page=content&id=TECH39418
09-26-2011 06:18 AM
Im curious. Is there such a thing as using synthetic backups for SQL?
Or maybe Exchange?