SharePoint 2003 and SQL Server 2008
Can theSharePoint 2003SQL Server 2000 database (backend) be migrated toSQL Server 2008? In other words, we want to useSharePoint 2003withSQL Server 2008.
Thank you.
January 29th, 2009 10:40am
I doubt it.
Even SQL Server 2005 required Service Pack 3 before it would work with WSS 2.0 / SPS 2003
WSS FAQ sites: WSS 2.0: http://wssv2faq.mindsharp.com WSS 3.0 and MOSS 2007: http://wssv3faq.mindsharp.com
Total list of WSS 3.0 and MOSS 2007 Books (including foreign language titles) http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/V%20Books.aspx
Free Windows Admin Tool Kit Click here and download it now
January 29th, 2009 11:03am
Hi there
I can confirm that SharePoint 2003 SQL Server 2000 Databases can be backed up and restored to SQL 2008 R2.
Stop all services and web on your SharePoint server before the move. Backup all your SQL 2000 databases.Restore them on your new SQL 2008/R2 database serverSetup a SQL Alias (make sure you DONT set the alias to 'Dynamic Port' or you may get the error below) on the SharePoint servers and after restarting SharePoint everything worked 100%.
Kind regards
Riccardo
Error if using Dynamic port on Alias .
--
If you move the SharePoint Portal Server 2003 databases to another computer
that is running SQL Server 2000, you may receive an error message that is
similar to the following when you try to access the portal site:
Array cannot be null.
Parameter name: Source
For example, you receive this error message when you click the link that is
displayed on the Web Parts Maintenance page. This error message may not be
caused by a Web Part issue. You may receive this error message in situations
when the TCP port that SQL Server 2000 uses is different from the TCP port
that SQL Server 2000 used on the original computer. Use Client Network
Utility to verify that the port that SQL Server 2000 uses is correct.
---
PS. Please remember to mark your question as answered if you got good advice.
August 31st, 2012 8:49am