Hello. I have posted here a couple times, received helpful advice in the past, thank you. I have a new problem, perhaps you could shed some light. I made some mistakes that has led to our intranet site being run on sql express rather than the intended sql server. We actually thought it was running on sql server, long story, my mistake, I realize it now. SQL Express has a 4GB db size limit and we have bumped up against it. In my absence my associate has truncated logs and such, and has freed up a small amount of space such that the site is up and online. However we are on the edge of our seat. My question is, and I realize that we need to move the site to full sql, but the question is, how can we tell what is taking so much space in the db? 4GB seems unlikely. Ours is an intranet serving 100 users, went live in December 2009. True we have photo gallery (Ventrian Simple Gallery) and blogs (Ventrian NA) as well as a bunch of pdf's in Documents modules. But the db simply points to the photos and documents, does it not? Seems strange that we would fly up to 4GB in a few months. Well, eating humble pie here. Please advise. Doxey

4GB does sound very large for what you are running, you may have log files that have grown, check this tutorial:
Site logs, Event logs and Scheduler

To check the size of a table, you can right click on a table in SQL Server Management Express and select properties, in the information it provides the data size of the table.

Look here for some SQL code that will tell you what is taking up space in your database.

Also, IowaComputerGurus.com has a nice free module that sets up scheduled tasks that trim your database tables.

Thanks so much.  My associate ran the query and yes it appers site log is 4gb.  He has the system online and he is trying to purge the log but no go.  I am logged in there now, trying also.  We receive this:

Description	Ran On Server	Duration (seconds)	Succeeded	Start/End/Next Start
Purge Site Log Site Log purge failed. System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket() at System.Data.SqlClient.TdsParserStateObject.ReadBuffer() at System.Data.SqlClient.TdsParserStateObject.ReadByte() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.DeleteSiteLog(DateTime DateTime, Int32 PortalId) at DotNetNuke.Services.Log.SiteLog.PurgeSiteLog.PurgeSiteLog() at DotNetNuke.Services.Log.SiteLog.PurgeSiteLog.DoWork()	DOTNETNUKE3-/LM/W3SVC/1/ROOT	35.033	False	S: 5/24/2010 10:08:53 AM E: 5/24/2010 10:09:28 AM N: 5/24/2010 12:08:53 PM

have you tried:

Login as host, go to the Host, SQL page and enter the following SQL commands:

truncate table eventlog
truncate table sitelog

Run this as a script.

Ah yes, you fixed me up.  Thanks so much.  I wish there was something I could do for you.  If ever you are in Seattle I would surely like to buy you a pint.

Cheers.
Doxey 

Hello,

That's great, glad to hear it is fixed. If you would like to add a testimonial, it would be really appreciated:
http://www.dnncreative.com/Forum/ta...fault.aspx

Thanks,