Newbie questions

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

Newbie questions

Postby MartinH » Wed Dec 01, 2010 8:44 am

I have just purchased SQL Virtual Restore 2.2 (I was waiting for encrypted SQL Backup support) and have a few questions.

1) In the documentation it states that SQL VR requires HiperBac to work, I have only purchased a license for SQL Virtual Restore 2.2, do I need to activate HiperBac as well?

2) In the documentation it stats that the actual backup file is never modified, in that case where are the changes made to the database stored?

3) How should I detach a SQL VR database, the same way I do for a normal database?

4) Let's imagine I attach a SQL Backup file via SQL VR on Monday, work with this modifiing some data and then wish to use an updated backup copy on Friday. The changes I have made to the virtual database can be lost, I don't need to keep these. How should I go about using a new backup file on an existing SQL VR database?

Posts: 78
Joined: Fri Apr 15, 2005 8:13 am

Postby javen » Wed Dec 01, 2010 11:55 am


I have answered your questions below:

1) No you do not, you only need the HyperBac service running (which it is by default after installing SQL Virtual Restore), you only need to license SQL Virtual Restore

2) Changes made during recovery or after restore are saved in the virtual data and log files (vmdf, vndf, vldf) files, these files are compressed as well so they occupy minimal space

3) You should perform a backup of the SQL VR database, which you could then restore as a physical restore (or another virtual restore) on any other system. You cannot detach a SQL VR database however.

4) In this case you could simply do a subsequent Virtual Restore WITH REPLACE, which will over write the previous SQL VR database

Hope this answers your questions, let us know if not
Jeffrey Aven
Product Management - HyperBac Technologies
Red Gate Software
Posts: 50
Joined: Mon May 24, 2010 11:10 pm

Postby MartinH » Wed Dec 01, 2010 12:00 pm

All answered and understood.

Thanks very much for the quick response and concise answers, much appreciated.

Posts: 78
Joined: Fri Apr 15, 2005 8:13 am

Return to SQL Virtual Restore 2

Who is online

Users browsing this forum: No registered users and 0 guests