Red Gate forums :: View topic - Virtual Database stuck in (Restoring...)
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Virtual Restore 2
SQL Virtual Restore 2 forum

Virtual Database stuck in (Restoring...)

Search in SQL Virtual Restore 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
epetro



Joined: 31 May 2011
Posts: 55
Location: Zotec Partners

PostPosted: Tue May 31, 2011 8:08 pm    Post subject: Virtual Database stuck in (Restoring...) Reply with quote

I'm doing some 'what if' scenarios with the trial version of this product.

I manually stopped the service "HyperBac Control Service" while an active virtual database was attached.
The .sqb file exists on a unc path and is accessed via admin share.

I started the service about 20 min ago and the database is still listed as myDB_Virtual (Restoring...)

After waiting around 15 min, I attempted:
detach: (not an option)
Take offline: (not permitted while restoring)

I reran my RESTORE DATABASE script from the wizard.
After the command: "RESTORE DATABASE[myDB_Virtual] WITH RECOVERY" executed, all seems well.

I don't have the option at the moment to test a server restart, but this leads me to believe I will need to restore all virtual databases in the event of a server(or service) restart.

SO...
What can I do to avoid recovering all virtual databases after server restart ?


thanks in advance,
Back to top
View user's profile Send private message
javen



Joined: 25 May 2010
Posts: 50

PostPosted: Thu Jun 02, 2011 11:27 pm    Post subject: Reply with quote

The databases should not need to be restored in the event of a restart, they will recover like any other databases, the HyperBac service will start before the SQL Server service. You can minimize recovery times if you know a restart is imminent, by taking the virtually restored (or compressed with Storage Compress) database(s) offline and then bringing them back online afterwards. Stopping the HyperBac service during an operation is not properly representative of the order of events that happens in a restart. Let me know if this makes sense.
_________________
Jeffrey Aven
Product Management - HyperBac Technologies
Red Gate Software
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group