Red Gate forums :: View topic - SQL Virtual Restore & Database Server Clusters
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

SQL Virtual Restore & Database Server Clusters

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



Joined: 29 Oct 2009
Posts: 11

PostPosted: Thu Jan 13, 2011 11:10 am    Post subject: SQL Virtual Restore & Database Server Clusters Reply with quote

I downloaded SQL Virtual Restore yesterday to try it on our database server cluster and I felt disappointed to find that the product does not support clusters. The documentation does not state that the software is not compatible with clusters, only the help button next to the instance selection states that it can only select local instances.

Out of curiosity, I did select one of the clusters that were running on this particular physical node; and VirtualRestore failed to connect to the instance (not much of a surprise).

Please can you make it a little clearer on the documentation if the software will support a clustered instance or not.
Back to top
View user's profile Send private message
javen



Joined: 25 May 2010
Posts: 50

PostPosted: Sun Jan 16, 2011 1:04 am    Post subject: Reply with quote

SQL Virtual Restore fully supports clustered instances of SQL Server, you just need to install on each physical node/host. We apologize if this is not clear in the doco and will seek to improve this.
_________________
Jeffrey Aven
Product Management - HyperBac Technologies
Red Gate Software
Back to top
View user's profile Send private message
PhilJax



Joined: 29 Oct 2009
Posts: 11

PostPosted: Mon Jan 17, 2011 11:05 am    Post subject: Reply with quote

Hi Javen,
Thank you for your reply, I have installed the software on both instances, unfortunately the software is not able to connect to any of the clustered instances actively running on the physical server. I only get an error stating 'Could not connect to instance'.

I admit that I did make the assumption that the software was attempting to connect to localhost\instancename or clustername\instance rather than clustergroupnetworkname\instancename because I have no issues connecting to the instances using SSMS or Red Gate Backup etc.
Back to top
View user's profile Send private message
tiestvilee



Joined: 12 Oct 2010
Posts: 5

PostPosted: Tue Jan 18, 2011 11:40 am    Post subject: Reply with quote

Hi PhilJax,

The SQL Virtual Restore wizard is a tool that creates and runs a T-SQL restore command. While the wizard is not written to work with clusters, you can use your own T-SQL to restore backups using SQL Virtual Restore, even to clusters.

To perform a restore, install SQL Virtual Restore on your clusters, then run your normal restore script but change the extensions for the *.mdf and *.ldf files to *.vmdf and *.vldf.

For more information on how to restore a backup see the worked examples, specifically the section at the bottom of the page titled 'Running T-SQL RESTORE commands to virtually restore from the backup files.'
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