Upgrade 5.4 to 6.3 with Multi server registration

ChrisAVWoodChrisAVWood Posts: 361
edited January 13, 2010 12:30PM in SQL Backup Previous Versions
Hi,

We are in the process of upgrading from 5.4 to 6.3 running on SQL2005 SP2 builds. On most of our servers the GUI only has the local server registered but on one server there is the local server and a further server registered in the GUI.

I want to upgrade from 5.4 to 6.3. Should I remove the remote server from the GUI first and then upgrade or upgrade then remove the extra server?

What will removing the extra server from the GUI do?

Thanks

Chris
English DBA living in CANADA

Comments

  • Eddie DEddie D Posts: 1,641 Rose Gold 5
    Thank you your post into the forum.

    You do not need to remove registered servers. The upgrade from SQL Backup V5.4 to Version 6.3 is a two part process.

    You will need to upgrade both the SQL Backup GUI and the server components.

    So on the server that has a GUI and the only registered server is the local server, no problem simply upgrade the GUI and deploy the server componets to the registered server.

    On the machine that has multiple servers registered. Upgrade the SQL Backup GUI and then deploy the Server components to each of the registered servers.

    When you first re-open the GUI after upgrading it , it will bring a reminder box that the server components need to be upgraded. When you view the regsitered server, a cog icon will be displayed to the right of the server to indicate that an upgrade is available.

    If you have already upgraded the server components for the registered server, there will be no cog icon to the right of the server name in the registered servers panel.

    A new feature added to SQL Backup V6.3 is the ability to activate multiple servers, so if you have multiple servers regsitered into the GUI registered servers panel form the Tools menu ->Utilities ->Multi-server Activation.

    This new feature maybe useful to you, as by applying SQL Backup V6.*, activation is set back to trail license and you will need to re-activate after upgrading.

    This sticky forum post contains a link to a pdf document that contains upgrade instructions. It was originally written for upgrading to SQL backup V6.0/6.1 from previous versions. However the advice is still valid for you upgrading from V5.4 to V6.3:
    http://www.red-gate.com/messageboard/vi ... php?t=9346

    Many Thanks
    Eddie
    Eddie Davis
    Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]
  • Eddie,

    You misunderstand what I am asking.

    The 2 servers are in the acceptance server GUI but one is from development and the other one is the acceptance server. I will upgrade development at least a week before acceptance. I want to delete the development registered server from the acceptance GUI then I will upgrade it. I just want to know what this actually does?

    It should only affect the acceptance GUI and not have any effect on the development server I would hope.

    Here is the setup currently.

    DEV01 has DEV01 in its GUI for registered servers.
    ACC01 has both DEV01 and ACC01 in its GUI as registered servers.

    I want to remove DEV01 from ACC01 registered servers, upgrade DEV01 and at a later date upgrade ACC01.

    Chris
    English DBA living in CANADA
  • Eddie DEddie D Posts: 1,641 Rose Gold 5
    Thank you for your reply.

    The GUI on your acceptance server has two registered servers. A SQL Instance on the local machine and an instance from your DEV01 machine. It is the DEV01 instance where you wish to upgrade SQL backup.

    Simply open the GUI on the acceptance server, right click the server name for the DEV01 server and select option to delete.

    This action will remove the DEV01 server from the list of registered server in the acceptance GUI only.

    The server components installation will remain installed and the DEV01 GUI will still have the DEV01 listed as a registered.

    I hope the above answers your question.

    Many Thanks
    Eddie
    Eddie Davis
    Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]
  • Great.

    Just what I had expected but had never had to do before so I wasn't exactly sure.

    Chris
    English DBA living in CANADA
Sign In or Register to comment.