Adding a Failover server to an existing Unity 4.0 server

Unanswered Question
Aug 1st, 2007
User Badges:

I hope someone can answer this for me. I would like to add a Unity failover server to a UM server that is using MSDE and not SQL. I understand that to have failover, you need to be using SQL. Is there anyway to add this failover server without rebuilding the primary to include SQL? Thank you in advance for any help.

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Tommer Catlin Wed, 08/01/2007 - 14:56
User Badges:
  • Green, 3000 points or more

Sure its not SQL? Almost all Unity installs are SQL and MSDE.

What version Unity do you have? If it is 4.0, I would highly recommend upgrading to SQL SP4 and upgrading Unity to 4.2.1. Failover is flakie at the level you are on. (engineering patches, etc)

Also keep in mind, your failover server must match your primary server. OS, SQL, Unity, etc.

g_chan Thu, 08/02/2007 - 07:06
User Badges:

Thanks for your reply, I think it is only MSDE because the original server was a standalone with 24 ports, during the installation, does it not use just MSDE when the # of ports is less than 32? The customer has elected to stay on this build and not upgrade.

Tommer Catlin Thu, 08/02/2007 - 12:46
User Badges:
  • Green, 3000 points or more

With the newer versions, it really does not look at the number of ports when installing the database. The database is typcically SQL 2000 SP4 in 4.0.5 to 4.2.1.

This might be a TAC question that you could get a better answer on.

ranpierce Thu, 08/02/2007 - 13:19
User Badges:
  • Silver, 250 points or more

Yes you can upgrade MSDE to SQL, I think let me find a doc for you before you have to open a TAC case.


Tommer Catlin Thu, 08/02/2007 - 13:27
User Badges:
  • Green, 3000 points or more

Yeah, there is a SQL Script you can run to verify what version of SQL you are running. Im upgrading a SP3 to 4 tonight, then upgrading from 4.0.5 to 4.2.1.

Fun stuff


g_chan Tue, 08/07/2007 - 06:09
User Badges:

Thanks for this link. I did manage to find this after I posted, however I didn't know we are now on 4. I will be using their original installation disks, which is probably still sp3 and 3a.

Tommer Catlin Tue, 08/07/2007 - 07:55
User Badges:
  • Green, 3000 points or more

Here was my plan and it went flawless the other night.

- backup

- upgrade SQL database on 4.x

- Or, run the Unity MS patch "kit" that is available. It will update all patches for OS and MS related software

- update schema

- update Exchange if needed (if it's UM, then you have Exchange off box and it's probably 2003, Unity probably still has 2k admin on it)

-Run Updated permissions wizard

- Run software update

- update TSP software

Im leaving my upgraded 4.05 to 4.2.1 server "sit" for a week to make sure it is stable before I move to adding in failover.


This Discussion