Migrate Sharepoint DB to new SQL 2008 R2 server.

Question

I need to migrate a SQL 2000 server that contains a SharePoint database to a SQL 2008 R2 server

The SharePoint is actually a WSS 3.0, at this moment we do not want to move\migrate\touch the SharePoint server itself just the DB.

I have no clue how to start this project. Perhaps just backup the DB and Restore it in the 2008 server? Any help will be very much appreciated. Thanks!

---

Simon

Answer 1

Hello,

http://msdn.microsoft.com/en-us/library/bb677622.aspx

http://msdn.microsoft.com/en-us/library/ms144256.aspx

 

Thank you,

---

Anup | Forum Support| If you think my suggestion is useful, please rate it as helpful. If it has helped you to resolve the problem, please Mark it as Answer.

Answer 2

Hi Simon,

You may have a look at the articles below about this topic:

How to Migrate Companyweb to a SQL 2008 R2 Standard Instance on SBS 2011 - Part 3: Migrating the Content Database

Move/Migrate WSS 3.0 DBs from SQL 2005 to 2008R2

Best Regards,
Stephanie Lv

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.