Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

WSS 3.0:Windows2003

I have a content database that keeps growing for the name of simply, "WSS_Content"

This database is aside from all the other content databases that are linked to an web application, but located in the same directory. I count 5 CONTENT databases on this directory, but only 4 web applications (excluding the centraladmin). Trouble is it keeps growing in size and I need to know what it is and why its growing. Is this a default database of some kind? Where and why would it grow?

I recently found, through Central Administration, that one of my sites has a content database name of

"WSS_Content_(random numbers and letters)"

whereas, the other content databases would have a name like

"WSS_Content_(WebApplicationName)"

What gives?

share|improve this question
    
I found the problem. The "WSS" in "WSS_Content" through me off, it was located on another web application on another server. Will deleting sites/document libraries and files downsize this database, or will that do minimal damage? –  Mike Apr 7 '10 at 22:03

3 Answers 3

up vote 2 down vote accepted

An easy way to see all your databases (and what web application they belong to) is to go to Central Admin -> Operations -> Perform a Backup.

This will give you a tree view of your farm with all of the databases listed.

share|improve this answer
    
There is nothing linked to WSS_Content though..hmmm... –  Mike Apr 7 '10 at 21:36
    
@Mike: then you have something wacky going on. (That is the technical term...) I would probably run a SQL Profiler trace to see where the connections to WSS_Content are coming from. –  MattB Apr 7 '10 at 21:42
    
WSS_Content was referencing a MOSS Web App (different server), that's where I got confused... –  Mike Apr 8 '10 at 1:10

Use the following code to see which table is the problem, and take action on the table. In my case, it was eventcache and eventlog that were causing the problems and I just had to run the timer job change log manually from sharepoint central administration.

Create Table FileSize_Temp(Name sysname, rows int, reserved varchar(100), data varchar(100), index_size varchar(100), unused varchar(100))exec sp_msforeachtable 'Insert Into FileSize_Temp Exec sp_spaceused ''?'''Select * From FileSize_Temp

drop table FileSize_Temp
share|improve this answer

I believe that SharePoint just puts a string of random numbers and letters after the WSS_Content db if you don't provide a name upon creation. Our SharePoint site was originally set up by a contractor and the default content db has the same random string you are talking about. I was not involved in the setup so I'm not sure what was done but my new web applications have proper names.

This technet blog covers the topic of sorting them out.

Edit: After reading through some of the subsequent articles on the link I provided it turns out that the admin content database doesn't give you an option to name it so it would automatically just be given a GUID. This could very well be the database you are seeing.

share|improve this answer
    
That a good reference, but I just want to know what WSS_Content is, and how can I downsize it without SQL, example being, expiration policy. –  Mike Apr 7 '10 at 21:39
1  
I'm assuming that your WSS_CONTENT database is the one that's created upon installation of SharePoint. That's the most likely one to not have been named. I've found the databases for SharePoint do tend to grow a lot and I haven't found much I can do to limit it. My one suggestion would be to ensure that you're taking log backups. If you're not the log files will grow to be very large. Regular log backups won't make your database any smaller but it will clear out the unused space in your log so it doesn't grow any more than it needs to. –  Sean Howat Apr 8 '10 at 14:13

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.