Moving SharePoint Foundation 2010 Databases

I have SharePoiint 2010 Foundation installed in a stand alone configuration.The database is SQL Server 2008 express. I need to move the database from the local express server to another box with SQL Server 2008 R2 Standard installed. The local SQL Server has 5 databases created by SharePoint.

Is moving the databases as easy as backup and restore on the new box? Then using Central Admin to set the SharePoint DB to point to the new database location?
105881Asked:
Who is Participating?
 
HumpdyCommented:
Hi,

That's all you have to do, if you're not migrating the actual sharepoint server, then just do a full backup of your DB's, restore them to the new location, and repoint sharepoing (with Central Admin) to the new DB server.

Be careful on the security, you may have logins in SQLExpress that are been used by sharepoint, so you may have to transfer the logins, as well as the databases.
Also, if you have any jobs running on your current db, you may want to script them out for deployment on your new server.

You can also do detach and attach, and there is a technet article specificaly for sharepoint 2010 database only migration.

http://technet.microsoft.com/en-us/library/cc512725.aspx

0
 
105881Author Commented:
Thanks Humpdy. I wanted to make sure
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.