Red Gate forums :: View topic - Newbie questions
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

Newbie questions

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



Joined: 15 Apr 2005
Posts: 61

PostPosted: Wed Dec 01, 2010 9:44 am    Post subject: Newbie questions Reply with quote

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?

Thanks,
Martin.
Back to top
View user's profile Send private message
javen



Joined: 25 May 2010
Posts: 50

PostPosted: Wed Dec 01, 2010 12:55 pm    Post subject: Reply with quote

Hi,

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
Back to top
View user's profile Send private message
MartinH



Joined: 15 Apr 2005
Posts: 61

PostPosted: Wed Dec 01, 2010 1:00 pm    Post subject: Reply with quote

All answered and understood.

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

Regards,
Martin.
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