We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now


Sharepoint 2010 SQL Databases not in use

Medium Priority
Last Modified: 2012-05-11
Strange request but...

I think there are Databases in my SQL instance (created purely for SP 2010) which are not in use (for example, I created a DB for Project - I prefer to precreate my Databases, but can see that SP requires following :-

Project Reporting, Archive, Draft and Published

I have in addition, a Database which I created and pointed the Service to caleed _Proj_SP_Content. The issue is, since the four aforementioned Databases are the ones which SP 2010/Project Server 2010 are supposed to use, is my other Database _Proj_SP_Content actually in use and/or required ? Running an SP_WHO2 shows only one SPID anf this is for .NET SQlClient Data Provider, is sleeping and shows 0 for both CPU and IO.
I obviously don't want to decommission a Database which is in active use for SP - any suggestions please ? If I try a detatch, it shows 3 active connections.

Watch Question

Unlock this solution and get a sample of our free trial.
(No credit card required)
Justin SmithSr. System Engineer
Top Expert 2012

Take them offline, see what breaks.
I am sorry I should mention that stsadm Command

stsadm -o enumcontentdbs -url http://YourSPServerURL Or Application


Hi George - will try that command - I was aware that Services also require databases.

Hi Ach1lles - bit drastic in a Production environment :-)


Hi George

Can you advise the command to use for application please - e.g. secure store service

That Powershell script should do it for all.

I am sorry
I mentioned the 2007 version

In 2010 you can run this script from withing SP management PS

Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.