December 5, 2005 at 1:53 pm
HAVE FULL BACKUP OF PROD DATABASE ON MONDAY. Data is on Drive f:, log file is on Drive e:.
On Thursday, drive F: is irretrievably damaged and the prod database .mdb is lost. The Drive e: .ldf file is undamaged.
I restore Monday's backup. Is there ANY way I can use the contents of the thursday .ldf file to recover the transactions after monday? Due to other problems there are no 'transaction log' backups after monday although I DO have the entire undamaged .ldf file from the point of failure.
December 6, 2005 at 6:23 am
If you use SQL2000, the recovery model is full and there were no log backups between mon full backup and the point of failure, you might see this article:
http://support.microsoft.com/default.aspx?scid=kb;en-us;253817
these steps should help you to recover transactions from ldf. file. One sidenote - the dummy database must have the same name as the original one, because if not log backup can't be applied to the database of different name - at least I couldn't make it work when I was testing this scenario. After you get the log backup, you restore full backup with norecovery clause and then appy the log backup.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply