Red Gate forums :: View topic - Post Upgrade Issue on a Cluster with registration
Return to www.red-gate.com RSS Feed Available

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

Post Upgrade Issue on a Cluster with registration

Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
ChrisAVWood



Joined: 18 Dec 2007
Posts: 308
Location: Edmonton, Alberta, CANADA

PostPosted: Mon Sep 17, 2012 4:16 pm    Post subject: Post Upgrade Issue on a Cluster with registration Reply with quote

Hi,

I have recently upgraded our servers from using V 6.5 to V 7.1. This is on SQL2005 servers that are both standalone and 2 node clusters. After I have upgraded the GUI I run the SQBServerSetup.exe to upgrade the server component. Then when I open the GUI it prompts me to enter the serial number which I do and the Trial Period Icon diappears.

This is quite simple for a standalone server but I have noticed an interesting situation on a dual node cluster. I prefer to do a clustered upgrade individually so I upgrade the GUI on the inactive node then do the same on the active node then run the SQLServerSetup.exe on the active node then do the same on the inactive node. I now open the GUI on the active node and then the inactive node to check that I am now running the newest version. I get prompted to input the serial number which I will do on the active node and have to do this manually because of limited internet access from the server and then the Trial period Icon disappears on both nodes.

Now my problem has come later when suddenly SQLBackup decides that my Trial Period has ended so now my backup jobs fail.

First is there a way, probably in the registry that I can see if SQLBackup thinks it is not registered. These are 64_bit systems. Could this be the HKLM\Software\Wow6432Node\Red Gate\Licensing\SQL Backup\Serial Number?

Now does this happen because of an issue with the upgrade or how I do the upgrade?

I am a little concerned because I upgraded 3 clustered Production servers 8 days ago and don't want SQLBackup to fail.

Thanks

Chris
_________________
English DBA living in CANADA
Back to top
View user's profile Send private message
ChrisAVWood



Joined: 18 Dec 2007
Posts: 308
Location: Edmonton, Alberta, CANADA

PostPosted: Tue Sep 18, 2012 3:44 pm    Post subject: Reply with quote

This happened again today on a test server. I checked the regkey I mentioned and could see the serial number present before I registered again.

I am now more curious as to what makes SQLBackup think it is running a Trial.

Chris
_________________
English DBA living in CANADA
Back to top
View user's profile Send private message
stanori



Joined: 23 Apr 2012
Posts: 83

PostPosted: Tue Sep 18, 2012 11:25 pm    Post subject: Reply with quote

Hi ChrisAVWood,

Thanks for your post. We have opened a support ticket and we should be in contact with you shortly.

Thanks,
Steve
_________________
_________________
Steve Tanori
Product Support
Red Gate Software Ltd.
866-997-0378
Back to top
View user's profile Send private message
ChrisAVWood



Joined: 18 Dec 2007
Posts: 308
Location: Edmonton, Alberta, CANADA

PostPosted: Thu Sep 20, 2012 3:26 pm    Post subject: Reply with quote

Thanks to Steve I will use a different method to activate after a version upgrade and I also know if a server, standalone or clustered, has a license file.

For W2K3 look in "%ALLUSERSPROFILE%\Application Data\Red Gate\Licenses\" for a v9_0.lic file where v9 is the version. In my case it would be v7_0.lic. The ALLUSERSPROFILE turns out to be C:\Documents and settings\All Users

For W2K8 look in C:\Program Data\Red Gate\Licenses for the v7_0.lic file. The Program data folder is hidden by default.

My new activation method will be by using the GUI Tools/Utilities/Product Activation and use this on both nodes.

Chris
_________________
English DBA living in CANADA
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