Solved

Moving SharePoint Foundation 2010 Databases

Posted on 2010-11-17
2
925 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

763 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