Backup

Last Post 12 Nov 2009 02:31 PM by sql-tips. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
sql-tips
New Member
New Member

--
09 Nov 2009 12:54 PM
I have full backup scheduled to run every day at 10 PM and transaction logs for every 2 hours.

My backup takes approximately 1 hour.

Now question is: My full backup failed, I started job manually at 11:30 PM, now what happens at 12 AM when my transaction log job schedule to run at 12. Do I have to disable this transaction log job and enable when full backup is done?

sql-tips
New Member
New Member

--
12 Nov 2009 02:31 PM
Thanks for your reply. If I have to apply transaction logs, shall I ignore 12 AM one and start applying from 2 AM?
sql-tips
New Member
New Member

--
07 Jan 2010 09:25 AM
Also, If I do log shipping. I don't have to take transaction logs backup right?
You are not authorized to post a reply.

Acceptable Use Policy