Reattach Sharepoint content database

Posted on 2012-09-14
Last Modified: 2012-09-20

I detached Sharepoints own content database from itself and now sharepoint administrator will not open. Pretty stoopid eh?  How can I fix please?
Question by:ryanbe
    LVL 51

    Accepted Solution

    Did you detach it using SQL or within SharePoint?

    Which content database did you detach?  If it's the one for the Central Administration site, then it's the trickiest to fix.

    This article from Microsoft explains how to attach a content database using Central Admin and the command line using PowerShell

    If it is the Central Admin content database then it's trickier to fix.

    Author Comment

    Hi tedbilly,

    Yes I believe I dettacjed the central admin content database from within the Central Admin  site :(

    I will read that article tomorrow thank you.
    LVL 2

    Assisted Solution

    Hello tedbilly,

    You can run the products and technologies wizard and create a new database for central administration site. This is a recomended step by microsoft. Once the central administration database is dettached its is difficult to reattach it back.
    LVL 51

    Assisted Solution


    I've never had trouble reattaching the Central Admin content database.  The only one I've ever had trouble with is the service provider DB's in MOSS 2007.  SharePoint 2010 has made it safer to do and to be honest I've often run into problems with the wizard and actually do not run it.  I do everything manually using the command line.  That way I can do things like name the databases without the long GUIDs

    Author Closing Comment

    Thanks everyone for the input, the server pros we hired to fix it could not manage to either.
    Personally I think they make it ridiculously easy to completely munt it.
    Have a nice weekend.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Microsoft AD for Secure LDAP 3 31
    Cumulative Updates 1 32
    Remote access server vs NAP 4 35
    Best practice DHCP migration 7 40
    Experts-Exchange users below are the steps you can follow to upgrade your Lync server to latest CU's or cumulative updates. Note: Perform it during non-production hours.   Step 1: Backup your lync and SQL server database. Follow below article: h…
    These days socially coordinated efforts have turned into a critical requirement for enterprises.
    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.
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    729 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

    19 Experts available now in Live!

    Get 1:1 Help Now