I Want to move windows sharepoint services 2 database which is currently running on sql server 2005 (Same server for WSS and sql server) to a separate Sql Server 2008 r2 (Clustered servers). The database has been copied, renamed and set up on a new clustered sql server 2008R2 server. It is running ok. It is the Windows SharePoint Services side that I need advice in what do I need to change on the IIS/SharePoint side to get my SharePoint Web site to work with the database on the 2008R2 clustered server.


Yes, it is entirely possible to move a database from SQL 2005 to 2008 and you have a number of options on how to do this:

  • Detach, move and then attach the database files
  • Perform a backup and restore from the old server to the new
  • Use the copy database wizard on SQL 2008 to pull the database across from SQL 2005

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.