[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Reattach Sharepoint content database

Posted on 2012-09-14
Medium Priority
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
  • 2
  • 2
LVL 51

Accepted Solution

Ted Bouskill earned 700 total points
ID: 38402139
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

ID: 38402808
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.

Assisted Solution

Shailendra_karve earned 300 total points
ID: 38403779
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

by:Ted Bouskill
Ted Bouskill earned 700 total points
ID: 38404349

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

ID: 38420550
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

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Question has a verified solution.

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

Back in July, I blogged about how Microsoft's new server pricing model, combined with the end of the Small Business Server package, would result in significant cost increases for many small businesses (see SBS End of Life: Microsoft Punishes Small B…
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…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

873 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