Sharepoint 2010 SQL Databases not in use
Posted on 2011-04-21
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.