I am receiving the following error message when I attempt to add a new Portal to DNN 6.2.5. Not really sure where to go from here. Does anyone have any thoughts regarding this?
The first problem is I hit the 4GB database limit on SQL and now all commands (Host->SQL) fail, even simple ones like use and select so I have no way to truncate/delete/recover, etc
How does one small site with no traffic could grow a database to 4GB so quickly? I am not talking about the database log here (that is only a few MB). The actual database itself is 4GB already! What the hell could it be storing that is 4GB? I need to know why or it’s just going to keep growing to unmanageable size.
This DNN instance has one active portal, two additional portals created with nothing in either. This one active portal has maxed out 4GB in roughly 6 weeks.
Here is some information about the setup.
We did the standard installation of DNN and it puts the database's data file and transaction log here by default.
C:\inetpub\wwwroot\dotnetnuke\App_Data\Database.mdf
C:\inetpub\wwwroot\dotnetnuke\App_Data\Database_Log.ldf
We use SQL Server 2008 Express and for future reference I prefer to only use sqlcmd.
BTW, it appears that no one can answer my primary question, which is why did the database grow so large so quickly. Speculation is fine.
fter running the dbcc shrinkdatabase command the database size didn’t change.
name IsDataFile IsLogFile size spaceused CurrentSizeMB SafeSizeMB
Database 1 0 524184 524048 4095.19 4094.13
Database_log 0 1 96 58 0.75 0.45
Error parsing Website TemplateCould not allocate space for object 'dbo.Tabs'.'PK_Tabs' in database 'C:\INETPUB\WWWROOT\DOTNETNUKE\APP_DATA\DATABASE.MDF' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() 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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.ExecuteScalar(String ProcedureName, Object[] commandParameters) at DotNetNuke.Data.SqlDataProvider.ExecuteScalar[T](String ProcedureName, Object[] commandParameters) at DotNetNuke.Data.SqlDataProvider.AddTabToEnd(TabInfo tab, Int32 createdByUserID) at DotNetNuke.Entities.Tabs.TabController.AddTabInternal(TabInfo tab, Int32 afterTabId, Int32 beforeTabId, Boolean includeAllTabsModules) at DotNetNuke.Entities.Tabs.TabController.AddTab(TabInfo objTab) at DotNetNuke.Entities.Tabs.TabController.DeserializeTab(XmlNode tabNode, TabInfo tab, Hashtable tabs, Int32 portalId, Boolean isAdminTemplate, PortalTemplateModuleAction mergeTabs, Hashtable modules) at DotNetNuke.Entities.Portals.PortalController.ParseTab(XmlNode nodeTab, Int32 PortalId, Boolean IsAdminTemplate, PortalTemplateModuleAction mergeTabs, Hashtable& hModules, Hashtable& hTabs, Boolean IsNewPortal) at DotNetNuke.Entities.Portals.PortalController.ParseTabs(XmlNode nodeTabs, Int32 PortalId, Boolean IsAdminTemplate, PortalTemplateModuleAction mergeTabs, Boolean IsNewPortal) at DotNetNuke.Entities.Portals.PortalController.ParseTemplate(Int32 PortalId, String TemplatePath, String TemplateFile, Int32 AdministratorId, PortalTemplateModuleAction mergeTabs, Boolean IsNewPortal) at DotNetNuke.Entities.Portals.PortalController.CreatePortal(String portalName, UserInfo adminUser, String description, String keyWords, PortalTemplateInfo template, String homeDirectory, String portalAlias, String serverPath, String childPath, Boolean isChildPortal)