Post reply

db in restoring

  • December 17, 2012 at 7:55 am

    #268345

    one of my db is in restoring status, we are unable to find the connections on the database .

    how can we make the database as normal ?

  • December 17, 2012 at 7:59 am

    #1569152

    Restoring or recovering?

    Restoring means that the DB is in the process of being restored from a backup. Check the error log, see what happened.

    Try RESTORE DATABASE <database name> WITH RECOVERY, will only work if the restore was run WITH NORECOVERY. If the DB restore is still running, you'll need to let it finish.

    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

  • December 17, 2012 at 11:42 pm

    #1569385

    Checkout this below mansion website would be help you in restoring your sql database.

    http://www.repairsqlserver.net/

    Thanks

  • December 18, 2012 at 1:53 am

    #1569404

    I would advise that you don't. There's nothing that suggests in any way that there's any corruption or damage to the DB, and if there was, repair software would not be the first choice to fix it anyway.

    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 4 posts - 1 through 3 (of 3 total)

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