Version upgrade Please help - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Version upgrade Please help

Author

Topic

rajkumarrai_bis
Yak Posting Veteran

78 Posts

Posted - 2008-10-23 : 09:37:08

We found that our Production SQL Servers are incompatible.
Productversion Productlevel Edition
Server1 9.00.1399.06 RTM Enterprise Edition
Server2 9.00.3042.00 SP2 Enterprise Edition

This means that if we want to move any DB then we simply can’t do that.
It requires version upgrade on Server1.

However these are production server with replication and clustering.
So version upgrade can create issues.

does this require a simple sql service pack 2 installation ?
please help...

SimpleSQL
Yak Posting Veteran

85 Posts

Posted - 2008-10-23 : 12:47:25

Hello RTM (Release to market) is base build. All you need to do is apply SP2 on Server 1 to get it to build 3042.

rajkumarrai_bis
Yak Posting Veteran

78 Posts

Posted - 2008-11-25 : 03:37:01

Hi,
sorry for coming back so late :(
just wanted to confirm if it would be safe to apply SQL SP2 on an SQL RTM server
I am just worried about SQL replication and clustering.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources