December 17, 2012 at 7:55 am
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
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
December 17, 2012 at 11:42 pm
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
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply