Improve company productivity with a Business Account.Sign Up

x
?
Solved

Moving SharePoint Foundation 2010 Databases

Posted on 2010-11-17
2
Medium Priority
?
952 Views
Last Modified: 2012-08-13
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?
0
Comment
Question by:105881
2 Comments
 
LVL 10

Accepted Solution

by:
Humpdy earned 2000 total points
ID: 34162088
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
 

Author Closing Comment

by:105881
ID: 34162253
Thanks Humpdy. I wanted to make sure
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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.

Join & Write a Comment

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Watch the video of Kernel Migrator for SharePoint, which demonstrate the process easily of migration from SharePoint to SharePoint, OneDrive for Business & Google Drive servers, Public Folder to SharePoint, File Server to SharePoint. The tool has va…

605 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question