Video Screencast Help

Single pass backup for physical SQL Servers?

Created: 11 Jan 2013 • Updated: 21 Mar 2013 | 3 comments
This issue has been solved. See solution.

Hi all, again....

Sorry netbackup new to us, just purchased some 5220 appliances, so may have a lot of question.

Is there a away to backup our physicall sql servers in one policy/pass? at the moment i have a policy for sql servers and a policy for physical windows serves, so i ave machines in both polcies which may not be good?

Thanks

Andy.

Discussion Filed Under:

Comments 3 CommentsJump to latest comment

Mark_Solutions's picture

I am afraid not if they are physical - you need both policies

For virtual ones there is now the option in a VMWare backup

Also as a tip do make sure you have more than one SQL policy as you need one for each retention period you use - this is because it is the Default Application Schedule that determines the retention period of the backup and not your own defined schedule - so do be careful of this "got-ya"

Not a problem with having the same machines in both policies but i would advise making sure that the case of their names is identical in both sets of policies (always use upper or lower case for client names but do not mix them)

You should also set you SQL clients exclusions for the .ldf and .mdf files - these exclusions will not affect your SQL policies

Hope all of this helps

Authorised Symantec Consultant

Don't forget to "Mark as Solution" if someones advice has solved your issue - and please bring back the Thumbs Up!!.

SOLUTION
thejollyboys's picture

Mark,

Thanks for your quick reply, apologies for being a little "janet and john" but how do it set the exclusions on the physical windows policy?

I think the default schdule for both policies are the same.

Thanks.

 

Mark_Solutions's picture

From the NetBackup Admin Console go to Host Proerties - Clients

Double click the client involved to connect to its Host Properties and expand the Windows Client tree

In there you will see an Exclude Lists section.

Add the paths in the top section

You can just add *.mdf if you like but it will slow the backup processing down as it searches the whole client for such file so it is best to use something like C:\Program Files\MSSQL\Data\*.mdf (obviously to suit the locations where such files exist on each client)

The default application backup for each policy needs to have the retention period set as required - so a Dailt SQL Policy should have a different retention to a Weekly SQL policy (if that is how you work)

Hope this helps

Authorised Symantec Consultant

Don't forget to "Mark as Solution" if someones advice has solved your issue - and please bring back the Thumbs Up!!.