01-30-2013 08:09 AM
I am working in an environment where we are using Backup Exec 2010 on one network and 12 on another. I am the new DBA on staff and realized that the backup administrators are running full database backup and transaction log backup and they are overlapping. The transaction log backup is set to run every 4 hours and then the full backup starts at 8:00 pm so there is a transaction log backup running during the full backup. My concern is
A: Is this a Symantec best practice will the two conflict
B: What will happen if a restore is required (which transaction log do I stop at)
Any help is appreciated
Jeff
Solved! Go to Solution.
01-30-2013 05:03 PM
B: What will happen if a restore is required (which transaction log do I stop at)
In your case, you would stop at the one just after the time which you want to restore the database to. For example, you want to do a point in time restore to 5 p.m. and there is a log backup at 6 p.m. You would stop at the 6 p.m. log backup. You don't have to apply the 10 p.m. log backup.
There is no need to backup the transaction logs if the databases are not being used. Normally you would only backup the logs during office hours and you would use a time window to restrict the log backups to these hours.
Take a look at your restore requirements. If there is no need, you might want to do just one log backup a day. Do it after your database backup.
01-30-2013 02:00 PM
The two jobs overlapping do have the potential to cause issue with one another. Are these two jobs in a policy.. if so the policy should force a supercede in that job B should not kick off until job A has completed. if the jobs are in a policy i would suggest editing the policy and adding a template rule that says "if start times conflict <Template A "being the Inc" supercedes <Template B "Being the full">" That way there is no confusion or issue as to which job should be running at 8:00 when the full job kicks off. Are you seeing any type of failures or errors associated with the job.
01-30-2013 02:20 PM
Incase of standalone jobs: You can set a time window for transaction log backup to ensure that it will not start when full backup is in progress.
01-30-2013 05:03 PM
B: What will happen if a restore is required (which transaction log do I stop at)
In your case, you would stop at the one just after the time which you want to restore the database to. For example, you want to do a point in time restore to 5 p.m. and there is a log backup at 6 p.m. You would stop at the 6 p.m. log backup. You don't have to apply the 10 p.m. log backup.
There is no need to backup the transaction logs if the databases are not being used. Normally you would only backup the logs during office hours and you would use a time window to restrict the log backups to these hours.
Take a look at your restore requirements. If there is no need, you might want to do just one log backup a day. Do it after your database backup.
01-31-2013 06:08 AM