Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 575
  • Last Modified:

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.
0
Senior IT System Engineer
Asked:
Senior IT System Engineer
1 Solution
 
QPRCommented:
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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now