Does SQL Backup Support Fail-over Clusters?
Daniel Handley
Posts: 214
SQL Backup is supported in a SQL Failover Cluster.
To set this up follow the procedure for creating a SQL Failover Cluster and than install SQL Backup on the primary server.
This will install the extended store procedure in the shared master database, so it will be available to both.
However the second server will not have the GUI and command line interface. If needed it can be installed on the second server, but uncheck the option to install the extended store procedure.
Before we released the product we tested this setup and had no problems.
Here are some links that we used to setup our test environment.
http://www.microsoft.com/technet/prodte ... s2005.mspx
http://www.sql-server-performance.com/i ... erver1.asp
Dan
To set this up follow the procedure for creating a SQL Failover Cluster and than install SQL Backup on the primary server.
This will install the extended store procedure in the shared master database, so it will be available to both.
However the second server will not have the GUI and command line interface. If needed it can be installed on the second server, but uncheck the option to install the extended store procedure.
Before we released the product we tested this setup and had no problems.
Here are some links that we used to setup our test environment.
http://www.microsoft.com/technet/prodte ... s2005.mspx
http://www.sql-server-performance.com/i ... erver1.asp
Dan
Daniel Handley
Red Gate Software Ltd
Red Gate Software Ltd
