Virtual Database stuck in (Restoring...)

SQL Virtual Restore: Rapidly mount live, fully functional databases direct from backups

Virtual Database stuck in (Restoring...)

Postby epetro » Tue May 31, 2011 7:08 pm

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.

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

thanks in advance,
Posts: 55
Joined: Tue May 31, 2011 6:55 pm
Location: Zotec Partners

Postby javen » Thu Jun 02, 2011 10:27 pm

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
Posts: 50
Joined: Mon May 24, 2010 11:10 pm

Return to SQL Virtual Restore 2

Who is online

Users browsing this forum: No registered users and 0 guests