Video Screencast Help
Search Video Help Close Back
to help
Not able to make it to Vision this year? Get a sampling in the Best of Vision on Demand group.

Reason for duplicating selections in two separate jobs?

Updated: 21 May 2010 | 4 comments
travesty's picture
0 0 Votes
Login to vote

I have two backup jobs that run Monday through Thursday.  Both of these jobs are incremental jobs.  One job would be classified as backing up the C drive and any other drives an application might use.  The second job backups SQL databases.  Upon reviewing both jobs I have noticed that the C drive and other drives (Logs, backups, etc.) on the database servers are being backed up by both jobs.  To me this seems like data duplication and unnecessary.  Should this be done or do the drives only need to be backed up once in one job?

Comments

DR0701's picture
23
Apr
2009
1 Vote -1
Login to vote

Duplications

Are both your jobs being backed up to tape or disk?  Personally, I don't see any point in duplicating the backups (unless you're duplicating from disk to tape, but that's another matter) - you're only taking up valuable disk or tape space, and increasing the backup window too.

Hope this helps

Doug.

travesty's picture
24
Apr
2009
0 Votes 0
Login to vote

Both of the jobs are going to

Both of the jobs are going to disk first and then to tape right after.

travesty's picture
30
Apr
2009
0 Votes 0
Login to vote

Does anybody else have any

Does anybody else have any thoughts on this?

Ken Putnam's picture
30
Apr
2009
1 Vote +1
Login to vote

RE: Reason for duplicating selections in two separate jobs?

Upon reviewing both jobs I have noticed that the C drive and other drives (Logs, backups, etc.) on the database servers are being backed up by both jobs. To me this seems like data duplication and unnecessary. Should this be done or do the drives only need to be backed up once in one job?

Sounds like you are correct and are backing up your flat file data twice.  Try editing the Selection List for the Database backups, select "Text Mode"  and delete everyting except the databases (or create a new Selection List containing only the DBs) 

If this response answers your concern, please mark it as a "solution"