In-Place Upgrade of MSDE to SQL Server 2000 SP3a

[fuzzyocelot]

Hello everyone!

This is probably a silly question. I did a search and didn’t find much on the subject. I’m probably not doing the search right.

Anyway, I need to do an inplace upgrade of MSDE to SQL Server 2000 with SP3a on a Windows 2003 server. So far I plan on just putting in the SQL Server 2000 Standard Edition disks and see what happens. Then I’ll run the SP3a file (sql2ksp3) for SQL 2000. Do I need to do anything special?

Thanks!!

 

[fuzzyocelot]

Nevermind. Apparently I misunderstood or something. They wanted a new installation of SQL 2000. There is no MSDE on the new server. The databases are currently in MSDE but the vendor will upgrade them to 2000 standard edition.

 

[mrdenny]

Make sure that they don't pay the vendor to "update" the database files from MSDE to SQL Server Standard.

All you have to do is detach the databases from the MSDE instance, copy the physical files to the SQL Server machine, and attach them.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com