MERGING .LDF FILES OR RECOVERY USING THEM.

  • 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 post 1 (of 2 total)

You must be logged in to reply to this topic. Login to reply