cancel
Showing results for 
Search instead for 
Did you mean: 

How to configure veritas NetBackup for backups and restores of Microsoft SQL server

Ojiaku
Not applicable
Partner

How to configure veritas NetBackup for backups and restores of Microsoft SQL server

5 REPLIES 5

Andy_Welburn
Level 6

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

Oddy
Level 5
Employee

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

Altimate1
Level 6
Partner Accredited

May be this tuturial video could help:

http://www.symantec.com/connect/videos/netbackup7-ms-sql-backups

Regards

Muhammad_Nazaka
Level 4
Partner Accredited

Patrick_Butler
Level 4

Im curious. Is there such a thing as using synthetic backups for SQL?

Or maybe Exchange?