Servergrid UserLink

... connection ... education ... discovery ... information ...
Welcome to Servergrid UserLink Sign in | Join | Help
in
Home Blogs Forums Photos Downloads Servergrid Join Now Private Messages

sqlserver log clean

Last post 06-02-2008, 8:18 AM by samkaruta. 2 replies.
Sort Posts: Previous
  • sqlserver log clean

     05-30-2008, 10:05 AM

    • Joined on 04-22-2008
    • Brasil
    • Posts 8
    • Points 43
    • Top 25 Contributor
    I have a system with many INSERT and UPDATE. Use STORE PRCEDURES which increases the LOG in the database. Each time the file of LOG is nearing the end of the stipulated value, can not implement more INSERT and UPDATE, or my system STOPS. I have always to increase the file of LOG to use my system. I have been with 100MB of LOG every month and must increase, because there is a way to clear the LOG. I think the HSPHERE have a problem on that, or who knows, it should clear the LOG when it reached some 10% of the final, or someone you know any other solution?
  • Re: sqlserver log clean

     06-01-2008, 1:57 PM

    Moderator
    • Joined on 11-05-2006
    • Posts 71
    • Points 357
    • Top 10 Contributor
      Male

    Hello,  Hsphere does not support clearing the log manually.  You can increase the log file from within the control panel.  The log files are cleared every 24 hours. 

    http://servergrid.com/manual/mssql_support.html#quota

     

    Thanks.

  • Re: sqlserver log clean

     06-02-2008, 8:18 AM

    • Joined on 04-22-2008
    • Brasil
    • Posts 8
    • Points 43
    • Top 25 Contributor
    Sure, in my opinion I find it a failure of HSPHERE, see example:

    -- I have a database that runs a large Store Procedure
    -- Store Procedure that has several INSERTs and UPDATEs
    -- When the quota of LOG arrives near the end (Used transaction log file MB 35.66 out of 36.00 MB)
    -- My application will not be able to run for lack of space in the file of LOG

    So the only solution is to increase the file of the LOG SQLSERVER, which today is in the size 100MB
View as RSS news feed in XML
Powered by Community Server, by Telligent Systems