db in restoring

  • 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 ?

  • 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
  • Checkout this below mansion website would be help you in restoring your sql database.

    http://www.repairsqlserver.net/

    Thanks

  • 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