How do I move SP2010 databases to another server?

Posted on 2010-01-04
Last Modified: 2012-05-08
I recently installed SharePoint 2010 on a new 64-bit server and the database got automatically installed on the server with SQL Express.  I want to move the databases to another server that has SQL Server Enterprise Edition, but I can't find any directions anywhere that tell me how I'm supposed to do so.
Question by:influent1
    LVL 16

    Accepted Solution

    You are going to have to build out a new SP 2010 environment. You are using SQL Express because you selected the standalone installation. The simplest solution would be to build out a new SP 2010 FARM environment and then backup restore your site collection using the stsadmn -o backup/restore command.
    LVL 2

    Author Comment

    I haven't done anything with the new installation yet, so I can just uninstall and reinstall right?  This time I'll make sure to select Farm, I didn't understand the difference apparently.  Thanks.
    LVL 16

    Expert Comment

    Yes you should be able to uninstall and reinstall. Might be better if you started with a fresh clean OS though.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
    Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    737 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

    18 Experts available now in Live!

    Get 1:1 Help Now