Hi, I need to migrate our MOSS database from sql server 2000 on the same box to sql server 2005 on a different box. Can anyone advise me on exactly the best course of action to do this...or point me to any detailed tutorials. Thanks...

Hi Ireland75, There is a very good Technet article you can follow - make sure you follow the section "To move all databases to a database server that has a different name" there. Note there is a very confusing line "“The new database server must use the same version of Windows Server and SQL Server as the old database server”"in this article (NOT sure why)- just ignore that. I works fine otherwise - I myself tested this :-). Hope this helps! BlueSky2010

Hi Recently we did migration sql 2000 to sql 2008 · We will primarily follow the steps detailed in this article : http://technet.microsoft.com/en-us/library/cc512725(office.12).aspx · The steps involve the following action plan : o On the three SharePoint servers : on the services console – “disable” ALL the SharePoint services and ensure they are turned off. o Then shut down the three SharePoint servers. o Take backups of all the SharePoint databases from the SQL2000 server. o Move all the backups to the SQL2005 server. o Restore all the databases on to the SQL2005 server with the SAME corresponding names as present on the SQL2000 server. o Once the restore and database checks are complete, turn on all three SharePoint servers. o At this point, the SharePoint services are still turned OFF – this is important. o Then we set up the SQL alias on all three SharePoint servers : § Try the below steps on one SharePoint server at a time. § Start>Run>Type in "cliconfg" § Select TCP/IP on the "General Tab" then click on "Alias" § Click on "Add" § Select TCP/IP § Uncheck "Dynamically determine Port" the port number should be 1433. § In the "Server Alias" box type in the Old SQL server name host name – SQL2000ServerName\InstanceName § In the "Server Name" under Connection parameters mention the New SQL server host name – SQL2005ServerName\InstanceName § Click On "OK" o Now the Alias is set on all the three servers. o Turn OFF the SQLService on the SQL2000 server – so that the databases are no longer accessible directly on that server. o We need to verify that the alias is working. o Try the below steps on one SharePoint server at a time : § Create a UDL file : Right click on Desktop > Create a text file. § Rename the test file as test.udl. § Open the UDL file. § Under the "Provider Tab" select "Microsoft OLE DB Provider for SQL server. Click on "Next". § Under select or enter a server name type in "SQL2000ServerName\InstanceName”. § Use Windows NT Integrated Security. § Select the database on server [you can select any database]. § Click on Test connection. § "Connection succeeded" this indicates SharePoint server is able to communicate to New SQL server through the alias. o Once the alias working has been verified on all the three servers, we need to bring SharePoint back online. o First set all the SharePoint services in the Application server to Automatic and turn them ON. o Follow this by making all the SharePoint services Automatic and turned ON, on the other two WFE servers. o Once the services are all back up, verify that the sites are working. · Please test this action plan on a new test farm hosted on the same SQL2000 instance as the production farm so that you become comfortable with the process. · Once done, Please let me know its working or not ThRegards, Thirumal Rao s Thirumal Rao Dage

Hi, Have you resolved your issue? If anything is unclear, feel free to reply to the forum. Thanks, Rock Wang Forum Support Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.Regards, Rock Wang Microsoft Online Community Support

Hi Thirumal Rao, Thanks for replying...i have read your detailed tutorial and understand the sql server alias and this looks like a good solution...however i have 1 question. In your first line - 'on the three sharepoint servers' - i just want to be clear so we are both on the same page...could you explain what this means. NB we have moss completely installed on 1 box with sql server 2000 on the same box. We plan on leaving the MOSS install on this box but using sql server 2005 on another box as the db. We then plan on uninstalling sql server 2000 on the moss box. Thanks...

Hi Sorry...Actually for us we have three servers 2 front end and one index server thats why i mentioned. For you have only one server. So please follow the same steps for your single server its enough DTRThirumal Rao Dage