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