Server Management - Systems Insight Manager
cancel
Showing results for 
Search instead for 
Did you mean: 

In-place upgrade of database server hosting SIM databases from SQL 2000 to SQL 2005

Thomas Olsen_1
Frequent Advisor

In-place upgrade of database server hosting SIM databases from SQL 2000 to SQL 2005

Hi all

I have an HP SIM 5.1 installation (running on Windows Servr 2003 SP1) with the databases on a separate SQL 2000 SP3 server (also running Windows Server 2003 SP1)

I am currently investigating if it is possible to do an in-place upgrade of this database server installation from SQL 2000 to SQL 2005 and retain my SIM system in working conditions.

Some help would be highly appreciated.

Thanks.

/Thomas
3 REPLIES
Newton S
Frequent Advisor

Re: In-place upgrade of database server hosting SIM databases from SQL 2000 to SQL 2005

Yes it works.
this is how we did.
1.Shutdown HP SIM Server
2.Upgrade the SQL DB to 2005
3.Reboot the SQL Server after upgrade
4.Start the HP SIM Server
Thomas Olsen_1
Frequent Advisor

Re: In-place upgrade of database server hosting SIM databases from SQL 2000 to SQL 2005

Hi

Thanks for the feedback. Glad that someone out there have done this upgrade successfully.
Have anybody else done this upgrade and encountered any issues?

Appreciate your help.

/Thomas
Rene Nascimento
Frequent Advisor

Re: In-place upgrade of database server hosting SIM databases from SQL 2000 to SQL 2005

I finally upgraded my SQL 2000 to SQL2005 before upgrading SIM to 5.3 SP1. I was pleasantly suprised to just disable the SIM services then perform a SQL inplace upgrade from SQL 2000 SP4 to SQL 2005 SP2. Had one error in the inplace upgrade that microsoft is aware of and you might experience as well, here's the link >
http://blogs.msdn.com/sqlserverfaq/archive/2009/07/15/upgrade-advisor-returns-error-while-upgrading-an-instance-of-sql-server-2000-to-sql-server-2005.aspx