Red Gate forums :: View topic - Remounting an existing virtual restore
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

Remounting an existing virtual restore

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



Joined: 28 Aug 2012
Posts: 2

PostPosted: Tue Aug 28, 2012 2:54 pm    Post subject: Remounting an existing virtual restore Reply with quote

If a backup has been mounted as a virtual restore on one server, is it possible to transfer the SQB and VMDF/VLDF/VNDF files to a new server and remount them there?
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 330
Location: Cambridge, UK

PostPosted: Thu Aug 30, 2012 3:04 pm    Post subject: Reply with quote

Unfortunately this wouldn't work. You would need to move the .sqb backup file and then run the virtual restore process again to create a new virtual database.
_________________
Chris Kelly
Technical Support Engineer
Back to top
View user's profile Send private message
LHardy



Joined: 28 Aug 2012
Posts: 2

PostPosted: Thu Aug 30, 2012 3:43 pm    Post subject: Reply with quote

Thanks for the reply. After some experimentation, I'd concluded that must be true. It is a shame, though. If I started over with the original SQB files, I would lose too much data for my present purposes, as the virtual mounts had been up for some time. So my only option was to make new complete backups of the old virtual mounts and then restore them again on the new server. This is fairly tedious, and it would be nice if there were an easier way. For your consideration.
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 330
Location: Cambridge, UK

PostPosted: Thu Aug 30, 2012 3:59 pm    Post subject: Reply with quote

SQL Virtual Restore was not designed for this kind of usage.

Your use case would be better suited by the sister tool SQL Storage Compress. It uses the same Hyperbac technology but in a different way. Basically it creates compressed .mdf, .ndf and .ldf files, rather than hooking into the backup file. More information can be found here: http://www.red-gate.com/products/dba/sql-storage-compress
_________________
Chris Kelly
Technical Support Engineer
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