Upgrading the version of SQL Server to 2008
I have an installation of MOSS 2007 on a server and the DB that we are attached to is SQL Server 2000 and it is on the same server as MOSS. I want to upgrade the DB to SQL Server 2008 and also to put the DB on a different server to MOSS. MOSS is being kept on the server it is on. Does anyone know if there would be any problems with upgrading to SQL Server 2008 ? Does anyone know how I would link my applications to their appropriate databases on the new DB server? Thanks, J.
May 19th, 2010 4:30pm

J, 2008 is fully supported. You might even consider Release 2 which is just out. The server move and relinking steps you need are often referred to as a Database Detach and Reattach. Full details are in Technet http://technet.microsoft.com/en-us/library/cc288554(office.12).aspx Basic steps are: dissassociate contendb in CA detach content db from SQL move database files to new server attach files in sql on new server reassociate contentdb in CA -Tom
Free Windows Admin Tool Kit Click here and download it now
May 19th, 2010 6:02pm

Thanks for the help Tom. J.
May 26th, 2010 2:13pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics