single netbackup sql policy backing up multiple clients

[BackupGuy2015]

hi

is it possible for netbackup 7.6 to backup multiple sql servers with one sql polcy? will that work? or do i have to resort using one policy one server. If I have more than 10 sql servers (dev/test/prod), then we are looking at least 10 backup policies and more for daily, weekly and monthly.

Is my understanding correct? or is there any easier way of doing this.

thank you

[Pangal]

Hi,

          Kindly create script with same name and same path in every server and it will work in single policy

[Marianne]

The same script name on all clients will work, but it does not solve the problem of the need for different daily/weekly/monthly policies and schedules.

See if this TN helps:

http://www.symantec.com/docs/TECH90544 
DOCUMENTATION: How to create a single MS-SQL-Server NetBackup policy which contains multiple schedules with different retention levels

[BackupGuy2015]

thanks pangal,

if i create same script name and same path, how about the sql hostname? wont that be different for every sql server.  for example below script:

OPERATION BACKUP
DATABASE $ALL
EXCLUDE “master”
EXCLUDE “msdb”
EXCLUDE “UserDB”
SQLHOST “SQLSERVER01″  <------- sql hostname
SQLINSTANCE “SQLINSTANCE_02″
NBSERVER “MASTER”
MAXTRANSFERSIZE 0
BLOCKSIZE 7
BROWSECLIENT “SQLSERVER01″
OBJECTTYPE TRXLOG
ENDOPER TRUE

[GulzarShaikhAUS]

You just need to make sure that the *name* of the script file is same. The contents can be different.

Eg. SQL server 1 - Script1.txt

  SQL server 2 - Script1.txt

Script1.txt -> on SQL server1

OPERATION BACKUP
DATABASE $ALL
EXCLUDE “master”
EXCLUDE “msdb”
EXCLUDE “UserDB”
SQLHOST “SQLSERVER01″  <------- sql hostname
SQLINSTANCE “SQLINSTANCE_02″
NBSERVER “MASTER”
MAXTRANSFERSIZE 0
BLOCKSIZE 7
BROWSECLIENT “SQLSERVER01″
OBJECTTYPE TRXLOG
ENDOPER TRUE

script1.txt -> SQL server 2

OPERATION BACKUP
DATABASE $ALL
EXCLUDE “master”
EXCLUDE “msdb”
EXCLUDE “UserDB”
SQLHOST “SQLSERVER02″  <------- sql hostname
SQLINSTANCE “SQLINSTANCE_02″
NBSERVER “MASTER”
MAXTRANSFERSIZE 0
BLOCKSIZE 7
BROWSECLIENT “SQLSERVER01″
OBJECTTYPE TRXLOG
ENDOPER TRUE

[BackupGuy2015]

Oh. got it SymGuy!!. 

same script name but each script in each sql server consists of the local sql server.

let me give this a try.

thank you

[GulzarShaikhAUS · Accepted solution]

For ease you can create multiple policies for each schedule i.e. daily/weekly/monthly. 

So for a set of 10 SQL servers you would have only 3 policies for each schedule.. 

As mentioned by Marianne multiple schedule is doable but very confusing so to keep it simple better you create one policy for each schedule.

[BackupGuy2015]

my thought exactly. will create a policy for each schedule.

so for 10 sql servers will be as follows:

1. backup_full_weekly

schedule:full, Friday

Retention: 7 days

client: multiple sql clients

full_backup_script.bch

2. backup_diff_daily

schedule:diff, Mon-Thur

Retention: 7 days

client: multiple sql clients

diff_backup_script.bch

3. translog_hourly

schedule:hourly

Retention: 7 days

client: multiple sql clients

translog_script.bch

looks OK?

[GulzarShaikhAUS]

Looks perfect!