March 25, 2010 at 4:43 am
Hi All.
I have implemented a full database back-up schedule as follows:
Midnight = Full database backup
Every 3 hours from between 02:00 and 11:00 = TLog backup
The log back-up which takes place at 2AM contains transactions which have taken place since 11PM the previous evening.
If I were to restore my database, which would be current as of 12PM and I then wanted to apply the log to roll the database forward to 2PM, would the fact that the log back-up contains changes which took place prior to the database back-up cause some kind of problem?
If so, how could this be avoided?
Thanks in advance for any help that you can provide.
March 25, 2010 at 4:54 am
no problem, sql server will figure it out.
March 25, 2010 at 4:57 am
Okay thats great, thanks very much for your prompt response.
March 26, 2010 at 7:35 am
The QOD on March 16th was kind of related to this:
http://www.sqlservercentral.com/questions/PBM/69340/
The key, in my mind to understanding how SQL Server "figures it out" is that everything is backed up to the point of completion of the full back up.
Regards,
Toby
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply