2

I restored Database from Backup File (in Management Studio) and after restore, Database showed Restoring, then I deleted files from disk (engine's stopped), then I tried Restore again with success, on both cases I leave Restore Process on Default Options

I have no idea why, dump file I created after restart of enviroment, without active Connection(s)

my question: is possible somehow to stop the Restoring status, if is there some tools for that

2 Answers 2

6

By default, a DB is not ready to use. It stays "restoring" ready to receive log restores.

Simply run this to bring the DB on-line

RESTORE DATABASE MyDB WITH RECOVERY

Or using the GUI, this is step 12 in the MSDN SSMS "how to" (a different place to what you mention)

2
  • +1 thanks for basic stuff, but I'm curious that on second attempt same dump, same virtual, same DbName and Databases was restored and works, hmmm btw that I never seen by using Sql_2005
    – mKorbel
    Commented Oct 10, 2011 at 18:51
  • 1
    @mKorbel: It could be some setting in the GUI, for example whether the DB exists or not. I almost always use raw SQL so can't really say sorry.
    – gbn
    Commented Oct 10, 2011 at 18:52
-2

So there are three ways you can restore the database

  1. No recovery RESTORE DATABASE MyDB WITH NORECOVERY
  2. Recovery RESTORE DATABASE MyDB WITH RECOVERY
  3. Standby RESTORE DATABASE MyDB WITH Standby

Thanks, Piyush Patel

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.