Solved

Moving SharePoint Foundation 2010 Databases

Posted on 2010-11-17
2
897 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 500 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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Update Query - What's wrong with this. 18 20
SharePoint 2013 Relational Database 8 57
Add Context Menu Item 4 43
T SQL Update Table from another table 5 40
The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
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…
I designed this idea while studying technology in the classroom.  This is a semester long project.  Students are asked to take photographs on a specific topic which they find meaningful, it can be a place or situation such as travel or homelessness.…
This is a video that shows how the OnPage alerts system integrates into ConnectWise, how a trigger is set, how a page is sent via the trigger, and how the SENT, DELIVERED, READ & REPLIED receipts get entered into the internal tab of the ConnectWise …

947 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now