SQL Server Central DB maintenance?

  • I've just failed to get my private messge because the 'The log file for database 'sqlservercentral' is full'

    That's got to hurt!

    ---------full exception------

    Server Error in '/' Application.

    --------------------------------------------------------------------------------

    The log file for database 'sqlservercentral' is full. Back up the transaction log for the database to free up some log space.

    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: System.Data.SqlClient.SqlException: The log file for database 'sqlservercentral' is full. Back up the transaction log for the database to free up some log space.

    Source Error:

    An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

    Stack Trace:

    [SqlException: The log file for database 'sqlservercentral' is full. Back up the transaction log for the database to free up some log space.]

    System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +742

    System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +196

    InstantASP.InstantForum.Logic.IndicateReadAndSendNotice(String intUserID, Int32 intPrivateMessageID)

    privatemessage.Page_Load(Object sender, EventArgs e)

    System.Web.UI.Control.OnLoad(EventArgs e) +67

    System.Web.UI.Control.LoadRecursive() +35

    System.Web.UI.Control.LoadRecursive() +98

    System.Web.UI.Page.ProcessRequestMain() +761

  • I saw this in one of the other forums.......

    ---------------quote--------------------

    , I know, I know. That's bad.

    We were trying out a new email system for our vendor mailing yesterday and the load happened a few minutes before the next T-log backup. Wasn't quite expecting this much data to go in

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

    The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

    http://www.dkranch.net

    ----------end quote--------------------

    -SQLBill

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply