asked on

Migrating Sharepoint 3.0 Internal DB to SQL 2008

Lots going on here which is making resources fairly difficult to find. I have the following configuration:

MS Sharepoint 3.0 running the internal database on a Windows 2008 Server 32-bit

SQL 2008 Standard running on Windows 2003 32-bit

I would like to migrate the content DB from WSS to SQL 2008 so I can really do some in depth reporting using SQL reporting services.

Should I do a detach and reattach? Restore from a WSS backup to SQL 2008 (is this possible)? Do a backup and reinstall everything properly with the database config?

static-void

Personally i would back it all up then do an upgrade on your sql box, its worked for me in the past... the other options will both work, personally i prefer backup restore.

static-void

oh actually one thing you should know is that you can only really backup and restore content databases. this means you need to reconfigure your farm which may be un-desirable

static-void

http://sharepointsherpa.com/2008/04/18/sharepoint-2007-move-content-and-configuration-databases/ shows how to reconnect a config DB,

nishant_shah_2002

Here is the recommended procedure
http://technet.microsoft.com/en-us/library/cc512725%28office.12%29.aspx

ASKER CERTIFIED SOLUTION

zephyr_hex (Megan)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

LeifHurst

ASKER

This worked for us. Uninstalled everything and restored the content databases to our SQL server. Went ahead and took this time to upgrade everything to 64-bit as well.

Thanks again!