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
Best Answer
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
Or using the GUI, this is step 12 in the MSDN SSMS "how to" (a different place to what you mention)