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

x

Sharepoint 2010 SQL Databases not in use

Medium Priority
241 Views
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.

Thanks
Comment
Watch Question

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

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

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

Author

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

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

Author

Commented:
Hi George

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

TY
That Powershell script should do it for all.


http://sharepointpsscripts.codeplex.com/releases/view/53114
I am sorry
I mentioned the 2007 version

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

get-SPDatabase
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.

OR

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.