I have a SharePoint 2007 farm which consists of a single application server and a separate SQL box.
The DB is SQL 2000. The objective is to upgrade to SQL 2008.
I have read countless articles on how to migrate the DB server from 2000/2005 to 2008. There does not seem to be a consensus on which approach is best.
One approach I do not see much written about is one I tried and successfully implemented.
What I did was simply take advantage of the built in backup feature in the central administration site. I performed a full backup of the site and copied the back up to a development
server in a different domain.
I then created a new farm in the development environment and pointed to a 2008 SQl database. The only databases in the farm after I created the farm were the config_Db and central
View Complete Post