11-26-2012 03:59 AM
Hi,
I have the request to create using the NetBcakup Agent MsSQL and the creation of policies (NetBcakup 7.5) a sequence as a whole of 3 different types of backups :
1st- File System(FS)
2nd- DB FULL
3rd- File System incremental ( to the same source of the 1st)
Is it possible to have a Policy that aggregates these 3 types of backups on the Symantec Netbackups ?
How can it be made?
Is it necessary to lauch it from the DB Server side and not from the Symantec Netbackup Master side ?
I do have Netbackup Client installed on the Server where the DB is running and where the FS is.
Thanks in advance for any help.
Best Reagards
Sílvia C.
Solved! Go to Solution.
11-29-2012 08:46 AM
As I have said your option to successfuly do this is as follows:
1. A file system policy with full and incremental schedules as required
2. A daily SQL policy
3. A weekly SQL policy
4. A monthly SQL policy
5. A SQL transaction log policy if desired
11-26-2012 05:43 AM
The full and incremental file system backups can go into a MS-Windows policy but the SQL backup must be in its own policy of the MS-SQL-Server policy type.
For the SQL Backup you will need to go onto the client first and use the NetBackup SQL Client (on the Start Menu) to configure SQL access and create the .bch file for the backup - you then point to that file in the policy
See the SQL Admin guide for full details
Also make sure you create a different policy for each SQL retention you want (daily, weekly etc.) as the retention is taken from the application backup schedule
Hope this helps
11-29-2012 07:50 AM
Hi Mark
Thanks for the indications.
I not sure however it will be possible to do it just by using Netbackups menus.
I think the Netbackup maybe not allow what I am looking for, just for the standard configurations Menus.
I think it has to be made with a script because the netbackup doesn't allow the configuration of Mixed FS-DB-FS schedules in its policies (I think). Am I wrong ?
Kind Regards
Sílvia Cardoso
11-29-2012 08:02 AM
Mixed FS-DB-FS schedules in its policies (I think). Am I wrong ?
yes and no :) this is what you need to make NetBackup and your users happy
a FS Policy with Full and Incremental Schedules
and DB Policy with Full Schedule
11-29-2012 08:09 AM
Hi Wr
Thanks for the indications but what I need is just one policy that could contain the in its schedules the 3 types of backup:
1st FS Full
2nd DB full
3rd FS inc
Could this be made, or not, even creating the policies you mentioned ?
Best Regards
Sílvia C.
11-29-2012 08:11 AM
You need one policy for File System plus SQL policies for each retention period that you need
So if you have daily, weekly and monthly retentions you may need three SQL polcies
You cannot do it all in one policy
11-29-2012 08:11 AM
you must have two policies; cannot combine Filesystem and DB Agent in one
11-29-2012 08:42 AM
Hi Wr
So what in your opinion maybe a solution to this requirement using Netbackup ?
Thanks
11-29-2012 08:46 AM
As I have said your option to successfuly do this is as follows:
1. A file system policy with full and incremental schedules as required
2. A daily SQL policy
3. A weekly SQL policy
4. A monthly SQL policy
5. A SQL transaction log policy if desired
11-29-2012 09:31 AM
Hi Mark
Maybe I don't make myself clear.
The backup to do has to be done in sequence, even if the policies are created in separated.
I agree with you about the policies that shoul exist, but the question is how is assure using Netbackup that the backup sequence is 1st FS Full policy, followed be the MsSQL DB policy and then by the FS inc policy, if it isnot possible to do all these 3 on only policy.
Thanks
Kind Regards
Sílvia C.
11-29-2012 02:08 PM
The backup to do has to be done in sequence
(this is Will not Mark, but no matter) You can control sequence via Schedule windows. For example, start FS Full on Friday night, DB Full on Saturday night, FS Incremental on Sunday-Thursday nights.