Loading ...
Sorry, an error occurred while loading the content.
 

Re: MUGH-SQLCON SQL Logfile Size on our SQLServer

Expand Messages
  • Santhosh
    Also increase the error log count to 100 or 200 as per ur audit requirements. With :))s Santhosh Kumar S.J - MCTS ReadMe @ sqlspy.blogspot.com ReadMe @
    Message 1 of 3 , Sep 9, 2010
      Also increase the error log count to 100 or 200 as per ur audit requirements.

      With :))s
      Santhosh Kumar S.J - MCTS
      ReadMe @ sqlspy.blogspot.com
      ReadMe @ santhoshpakkangal.blogspot.com




      ________________________________
      From: SARADADEVI <sv_39@...>
      To: sqlcon@yahoogroups.com
      Sent: Thu, 9 September, 2010 7:44:28 PM
      Subject: MUGH-SQLCON SQL Logfile Size on our SQLServer


      Hi

      We requires that unsuccessful and successful login attempts be logged
      With the excessive log files now being created is it recommended/approved to
      only capture unsuccessful logins for Microsoft SQL Servers ?

      For one month 141,316 entries have been added to the SQL log file on our server
      Is this large number normal ?
      Will the log file become unmanageable ?

      There is also a significant number of logins for USA\sqlsvc - Why?

      [Non-text portions of this message have been removed]






      [Non-text portions of this message have been removed]
    Your message has been successfully submitted and would be delivered to recipients shortly.