Solved

Identifying unused Database in SharePoint 2007 and WSS 3.0 ?

Posted on 2014-03-27
2
553 Views
Last Modified: 2014-04-01
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
Comment
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 29

Accepted Solution

by:
QPR earned 500 total points
ID: 39967810
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
 
LVL 7

Author Comment

by:Senior IT System Engineer
ID: 39971373
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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question