Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 1 down vote favorite

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

share|improve this question

2 Answers

up vote 3 down vote accepted

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)

share|improve this answer
+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 Oct 10 '11 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 Oct 10 '11 at 18:52
up vote -2 down vote

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

share|improve this answer
This doesn't add anything to the accepted answer for this question, does it? – Paul White Mar 22 at 6:06

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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