Post reply

Cannot attach database that was bieng restored

  • August 17, 2009 at 12:50 am

    #213673

    Dear All,

    I had confirgured Log shipping in 2 of our servers. I had kept the secondary DB in standby mode.

    Since there was some problem in secondary server, our client uninstalled SQL server and reinstalled it again.

    Now when I checked MDF & LDF files of secondary DB are there in the folder. I tried to attach it and got the following error.

    "Cannot attach database that was bieng restored"

    What to do .? Pls guide. (Of course, I am searching in google as well....)

  • August 17, 2009 at 8:03 am

    #1040193

    Get out your database backup and restore it. You do have a backup, don't you?

    If a database is detached while in the restoring state (not possible on SQL 2008), it cannot be reattached.

    i.e. you should set up the log shipping from scratch.

    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

  • August 17, 2009 at 8:13 am

    #1040209

    Thanks Gila.

    There's no backup. Infact I had configured it day before only.

    I reconfigured it again today. Now log shipping is working. Just wanted to know if there's any way to reattach it again.

    Once again thanks.

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

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