backup the active transaction log

  • Hi, I try to backup the active transaction log of an sqlserver database which have a disk failure and I cannot !!!!

    I follow the Microsoft procedure but it does not work !!!

    http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q253817

    Is anyone run this procedure successfully ? I sanyone have an idea to do this ?

    Thanks a lot

    BR

    MADCHA

  • What happened, what exactly have you done, and what error are you getting?  More detail would be helpful.

     

    /*****************

    If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

    *****************/

  • The MS procedure recently worked for me, but just for testing purposes. The dummy database must have the same name as the original one, otherwise you cannot apply the log backup to your restored db. I'm not sure if they mention it in the article. But post more info.

Viewing 3 posts - 1 through 3 (of 3 total)

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