SQL Server 2000 Database Recovery

  • SQL Server is crashed, might me the SQL Server Database itself or the Server.

    MDF is in D drive (drive got crashed)

    LDF is in E drive (drive is good)

    We have Sunday Weekly full back and every day night differential backups and every one hour transaction log backup.

    See Friday 5 PM server or database is crashed and client says he can lose only 10 mins data and he wants data till 4:50 PM

    What are the steps u follow or how many ways u can do.

    Kindly provide the URL or Steps

    ...

    Regards,

    Mallikarjuna

  • Please note: 8 year old thread.

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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