Migrating from SQL 2000 to SQL 2005
Migrate a SHAREPOINT Instance of SQL Server 2000
The steps to migrate the SHAREPOINT SQL Server 2000 instance are nearly identical to the steps to migrate the SHAREPOINT WMSDE instance to SQL Server 2005 Workgroup Edition. Use the following procedure to migrate the SHAREPOINT SQL Server 2000 instance to SQL Server 2005 Workgroup Edition.
To migrate the SHAREPOINT SQL Server 2000 instance to SQL Server 2005 Workgroup Edition
Complete the procedure "To prepare the http://companyweb Web site," earlier in this document. Note that you must uninstall SQL Server 2000 by using Add or Remove Programs, not WMSDE.
|Before you uninstall SQL Server 2000, review Article 920899 in the Microsoft KnowledgeBase (http://go.microsoft.com/fwlink/?LinkID=68562). The article addresses known issues with uninstalling SQL Server 2000 with Service Pack 4.
Complete the procedure "To create the SQL Server 2005 Workgroup Edition SHAREPOINT instance," earlier in this document, to complete a new installation of SQL Server 2005 for Windows SharePoint Services.
Complete the procedure "To configure permissions for the new SHAREPOINT instance of SQL Server 2005".
If you are installing the Dutch, Swedish, or Portuguese (Brazil) versions of Windows SBS 2003 R2 Premium Edition, complete the procedure "Dutch, Portuguese (Brazil), or Swedish installations only," earlier in this document. Otherwise, skip this step.
Complete the procedure "To attach the database files to the new SHAREPOINT instance of SQL Server 2005."
If you enabled full-text searching for Windows SharePoint Services when you upgraded the SHAREPOINT WMSDE to SQL Server 2000, you do not have to enable it again after migrating to SQL Server 2005. If you did not enable full-text searching previously, follow the steps provided in the procedure "To turn on full-text search in Windows SharePoint Services," earlier in this document.
I was looking all over the cdrom for that section that talks about upgrading SQL 2000 sharepoint to SQL 2005 workgroup and I couldn't find it…. well it's because it's not on the cdrom version and it's only on the web one….I kept going… okay I KNOW there was a section about SQL 2000 to SQL 2005….where is it? Just a reminder… don't always rely on the cdrom versions of the instructions…. click on the link that says "click here for the latest version" and make sure you have the latest instructions.