Red Gate forums :: View topic - RedGate client installation on a cluster
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 6
SQL Backup 6 forum

RedGate client installation on a cluster

Search in SQL Backup 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
AngelaGalper



Joined: 21 Dec 2011
Posts: 1

PostPosted: Wed Dec 21, 2011 5:01 pm    Post subject: RedGate client installation on a cluster Reply with quote

I registered a SQL Server cluster from the RedGate console and started taking database backups. One of my Windows admins cautioned me that because the client software is installed on C:\ProgramFiles\Redgate ... on the current active cluster only (not on the passive) there is a risk that my cluster might not fail over properly.

This raises two questions:

1. How do I get the client software loaded on the passive node?
2. Do I have to have one license per node, and if so, how would I register it?
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 923
Location: Red Gate Software

PostPosted: Wed Dec 21, 2011 7:24 pm    Post subject: Reply with quote

Thank you for your post into the forum.

SQL Backup has two major components:

    1. SQL Backup GUI - This component is not cluster aware and does not require licensing and activation. It can be installed on as many machines as required including workstations. The GUI is for managing your SQL Backup, backup and restore activities.

    2. SQL Backup Server Components - This components does require licensing and activation and this installer is cluster aware. The server Components is the part that performs the work. When installed a service is created on each node called the SQL Backup Agent and 9 Extended Stored Procedures are created in the SQL Instance master database.


To answer your questions:
Quote:

1. How do I get the client software loaded on the passive node?
2. Do I have to have one license per node, and if so, how would I register it?


Answer 1 - To install the SQL backup GUI on the other node, simply run the SQLBackup_6.5.1.9.exe or the SQLToolbelt Installer.

Answer 2 - The SQL Backup GUI does not require any activation. However the server components do require activation. There are two methods for activating on a cluster. From the SQL Backup GUI ->Tools ->Utilities ->Cluster Activation Wizard or locate an executable called ProductActivation.exe, you will find by default in the GUI install folder \Program Files\Red Gate\SQL Backup 6 or \Program Files (x86)\Red Gate\SQL Backup 6 depending if your system is 32-bit or 64-bit-bit.

Each node of the cluster will require a licensing and activation.

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
jhboricua



Joined: 15 Mar 2011
Posts: 28

PostPosted: Fri Feb 17, 2012 10:33 pm    Post subject: Reply with quote

Angela,

I would strongly suggest that you add a disk dependency on the SQLBackupAgent generic cluster service in cluster administrator.

See this thread for reference:

http://www.red-gate.com/MessageBoard/viewtopic.php?t=13361

When you install SQLBackup on a cluster the registry key:

HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal\(LOCAL)

is populated with the path of the shared cluster disk you specified during install. There is an issue where if the cluster service for SQLBackup tries to start before the disk resource is online (like during a failover or a reboot), the key will get reset with a local path on the node, effectively wiping the backup history and timeline from the SQLBackup GUI. By adding the disk dependency you'll ensure the service won't attempt to start before the shared disk becomes available.
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