Solved

Moving SharePoint Foundation 2010 Databases

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

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
append correct value from linked sharepoint list field column 4 57
the way to learn Microsoft BI 13 70
MSSQL Convert Char to Date Time 5 36
Add Promise to Existing Code 6 30
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
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
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

738 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