change the MYSERVER\sharepoint database from MSDE to MSSQL2000

[ptidmarsh]

hi i have sql 2000 installed but how do i transfer my sharepoint database from being MSDE to MSSQL2000.

I have seen many links.
and tried many things.

http://support.microsoft.com/default.aspx?scid=kb;en-us;815013

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q325023

http://www.microsoft.com/downloads/...2C-0488-4E46-AFBF-ACACE5369FA3&displaylang=en

http://www.microsoft.com/technet/prodtechnol/office/office2003/maintain/bureswss.mspx

http://www.microsoft.com/resources/documentation/wss/2/all/adminguide/en-us/stsf17.mspx

http://www.microsoft.com/resources/documentation/sts/2001/all/proddocs/en-us/admindoc/owsl01.mspx

http://www.microsoft.com/resources/documentation/sts/2001/all/proddocs/en-us/admindoc/owsi07.mspx

http://www.microsoft.com/resources/documentation/wss/2/all/adminguide/en-us/default.mspx

http://www.sharepointwatch.com/top/...m-one-sharepoint-server-to-another/index.aspx

http://www.microsoft.com/technet/prodtechnol/windowsserver2003/technologies/sharepoint/movewsdb.mspx

http://www.forum4designers.com/message56876.html

http://wss.sharepointtips.com/Lists/FAQ/DispForm.aspx?ID=157

http://www.microsoft.com/sql/downloads/2000/sp4.asp

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546

..just a few!

the company that hosts our server installed sharepoint and mssql2000 but htey did not migrate the sharepoint msde over to sql2000. the search box on the sharepoint does not work.

In enterprise manager I can see the 'local' and 'MYSERVER\Sharepoint'. The local one is sql2000 - I know this because if i right click and go to properties, the MYSERVER\Sharepoint one is MSDE (right click go to properties). So the local one has full text search but the sharepoint one does not.

Any help with this would be appreciated!
Thanks!!
Paul

 

[ChaserNL]

Well the easiest way is to upgrade your (W)MSDE... that is if the 'local' isnt used. Then delete SQL server.

Insert the SQL server install disk (only standard and above), select the 2 option in the install menu and upgrade the (W)MSDE, dont forget to install the full text seach component.

and else follow the steps you posted your self:

http://www.microsoft.com/resources/documentation/wss/2/all/adminguide/en-us/stsf17.mspx#EAAA

 

[ptidmarsh]

i'll ask the server hosting company to supply me with the setup files that i need.

i suspect that there will be more hurdles after this but just in case they don't, and everything goes smoothly, thanks very much for your help!