Identifying unused Database in SharePoint 2007 and WSS 3.0 ?

Hi All,

How to determine which database is still in use by the SharePoint Server 2007 from:

Central Administration > Operations > Servers in Farm    

to see which one that I can delete or remove without causing any problem with the Sharepoint site.
LVL 9
Senior IT System EngineerIT ProfessionalAsked:
Who is Participating?
 
QPRConnect With a Mentor Commented:
Try going into the backup/restore area of central admin and select perform a backup. You'll see a list of the SP databases here. Then you can cancel out of the backup.

You can use powershell for this in 2010 but I don't know about 2007/2003
Can't hurt to try...
Open  powershell on the sharepoint server (web front end or app server, not DB server unless you have a single server farm)

add-pssnapin microsoft.sharepoint.powershell
Get-SPDatabase | Sort-Object disksizerequired -desc | Format-Table Name
0
 
Senior IT System EngineerIT ProfessionalAuthor Commented:
Yes, you are right man... if the database is not in use, it won't be listed under the complete SharePoint farm backup.
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.