Sharepoint 2010 SQL Databases not in use

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
LVL 11
TheGeezer2010Asked:
Who is Participating?
 
GeorgeGerguesConnect With a Mentor Commented:
You can find which databases are being used by SharePoint here

stsadm -o enumcontentdbs -url http://YourSPServerURL


Or you can get it from the Central Admin .

There is much more than just the content DBs that are being used,

The Application services each has one as well
0
 
Justin SmithSr. System EngineerCommented:
Take them offline, see what breaks.
0
 
GeorgeGerguesCommented:
I am sorry I should mention that stsadm Command

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

0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

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

Hi Ach1lles - bit drastic in a Production environment :-)
0
 
TheGeezer2010Author Commented:
Hi George

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

TY
0
 
GeorgeGerguesCommented:
That Powershell script should do it for all.


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

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

get-SPDatabase
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.