December 5, 2008 at 2:06 am
if one of the transaction log backup file in the
sequence is not available available the how to
restore to point in time
for eg. i have transactional backup file at 10
am and dont have 11 am file but have 12 pm
what is the way out
December 5, 2008 at 8:16 am
Hi,
If you had lost the 11am backup file then you can restore point in time upto 10am only. There is no way that you can restore up to 12
Thanks
Chandra Mohan N
[font="Verdana"]Thanks
Chandra Mohan[/font]
December 5, 2008 at 10:12 am
raviraikulkarni (12/5/2008)
if one of the transaction log backup file in thesequence is not available available the how to
restore to point in time
for eg. i have transactional backup file at 10
am and dont have 11 am file but have 12 pm
what is the way out
No way out. The log chain must be unbroken to restore. As soon as a log file is lost, all log backups after that point are useless until anther full backup is made.
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 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply