August 1, 2012 at 2:43 am
every Saturday full back : 10 PM
daily differential backup : 10AM
Tlog bkup happenes at every 1 hr like 9:30 , 10:30 ,11:30, 12:30... so on
DB crashed at 5 PM Wednesday.
so i am confused if i restore diff. bkup which was taken at 10:00 am, will it allow me to restore Tlog backup of 10:30? because according to concept of LSN numbers, 10:30's Tlog Bkp will luk for 9:30's Tlog Bkp in sequense right?
PLEASAE HELP
August 1, 2012 at 2:55 am
Please don't create multiple threads for the same problem.
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1338316-391-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply