+ Post New Thread
Results 1 to 12 of 12
Enterprise Software Thread, MSSQL Log Files are MASSIVE!!!! in Technical; Installed Kaspersky Admin Kit bout three weeks ago and it stopped working today. Log files on the SQL Server are ...
  1. #1
    Sam_Brown's Avatar
    Join Date
    Sep 2009
    Location
    Northampton
    Posts
    594
    Thank Post
    100
    Thanked 42 Times in 40 Posts
    Rep Power
    19

    MSSQL Log Files are MASSIVE!!!!

    Installed Kaspersky Admin Kit bout three weeks ago and it stopped working today.

    Log files on the SQL Server are now 118GB and rising. Disk now only has 10meg free on it!

    A) How do I decrease the log files?
    B) How do I stop it happening again?
    C) Is this why I can't get the Admin Kit working?!?!

    Thanks in advance

  2. #2
    gshaw's Avatar
    Join Date
    Sep 2007
    Location
    Essex
    Posts
    2,702
    Thank Post
    172
    Thanked 224 Times in 207 Posts
    Rep Power
    68
    Wow that's some huge logfiles, is that just being caused by KAV admin kit?

  3. #3
    Sam_Brown's Avatar
    Join Date
    Sep 2009
    Location
    Northampton
    Posts
    594
    Thank Post
    100
    Thanked 42 Times in 40 Posts
    Rep Power
    19
    Believe so.

    I've copied the log file now for safe keeping and truncated the original so it's down to 188MB as opposed to 120GB but I'm worried it's going to grow again over night! It just shot up from 60MB to 178MB in a few minutes!

    I've no idea why it's going up so quickly though. Kind of worrying.

  4. #4

    maniac's Avatar
    Join Date
    Feb 2007
    Location
    Kent
    Posts
    3,070
    Thank Post
    210
    Thanked 430 Times in 310 Posts
    Rep Power
    144
    Kaspersky is quite a hungry program when it comes to SQL, but it shouldn't cause that sort of problem. Our kaspersky database is about 1GB with the associated log file being about 470MB and that's on a 2 year old installation. What version of Kaspersky admin kit are you running and what version of SQL?

  5. #5
    Sam_Brown's Avatar
    Join Date
    Sep 2009
    Location
    Northampton
    Posts
    594
    Thank Post
    100
    Thanked 42 Times in 40 Posts
    Rep Power
    19
    8.0.2 Admin Kit
    2k8 SQL

  6. #6

    maniac's Avatar
    Join Date
    Feb 2007
    Location
    Kent
    Posts
    3,070
    Thank Post
    210
    Thanked 430 Times in 310 Posts
    Rep Power
    144
    Yes, version 8.0.2 is the latest admin kit. The full version number of the absolute latest version is Version: 8.0.2163

    I suggest keeping an eye on it initially and if the same behaviour repeats itself, it would be well worth giving their support a call, I've found them to be very helpful in the past. I've no suggestion to make myself except checking you have the very latest version of the admin kit.

    Mike.

  7. #7

    Join Date
    Mar 2008
    Location
    Surrey
    Posts
    2,217
    Thank Post
    116
    Thanked 332 Times in 274 Posts
    Blog Entries
    4
    Rep Power
    115
    What recovery mode is the SQL database set to?

  8. #8
    Sam_Brown's Avatar
    Join Date
    Sep 2009
    Location
    Northampton
    Posts
    594
    Thank Post
    100
    Thanked 42 Times in 40 Posts
    Rep Power
    19
    It was set to full. Although as a temporary solution I've turned it to Simple. At least until the boss gets back.

  9. #9

    Join Date
    Mar 2008
    Location
    Surrey
    Posts
    2,217
    Thank Post
    116
    Thanked 332 Times in 274 Posts
    Blog Entries
    4
    Rep Power
    115
    That should at least keep the logs from exploding - seen the same thing many a time with SharePoint.

  10. #10

    Join Date
    Dec 2007
    Location
    Derbyshire. Ish.
    Posts
    266
    Thank Post
    29
    Thanked 23 Times in 16 Posts
    Rep Power
    24
    Our AVG install does the same thing on occasion - while the database itself is reasonable, the transaction log file is getting distinctly towards the ruddy massive side now and is regularly knocking on the defined upper limit. When it does, the AVG admin server stops working.

    A backup with truncate does nothing, neither does a shrinkfile. The only thing I can do is grant it more space.

    Me no likey that one and I'd love to know what it's up to - I really must get to the bottom of it when I have more time....

  11. #11
    Sam_Brown's Avatar
    Join Date
    Sep 2009
    Location
    Northampton
    Posts
    594
    Thank Post
    100
    Thanked 42 Times in 40 Posts
    Rep Power
    19
    Hi TheCrust,

    As well as settig the Recovery Mode to simple as above you can also edit the database properties to limit the size of the T-Logs.

    You can manually truncate the T-Logs with a T-Sql command and then set the size of the T-Logs under database properties to something manageable like 1GB.

  12. #12

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    2,025
    Thank Post
    118
    Thanked 512 Times in 346 Posts
    Blog Entries
    2
    Rep Power
    288
    Are you actually backing up the database?

    Ever-expanding log files are a sign of a backup problem. The log file is not being truncated.

    Here's a nice little SQL script that shows the physical and logical sizes of the files in use by a database.


    Code:
    use [the_name_of_your_database] 
    go
    
    dbcc showfilestats
    
    SELECT	Name, Filename,
    
    CONVERT(Decimal(15,2),ROUND(a.Size/128.000,2)) [Currently Allocated Space (MB)],
    
    CONVERT(Decimal(15,2),ROUND(FILEPROPERTY(a.Name,'SpaceUsed')/128.000,2)) AS [Space Used (MB)],
    
    CONVERT(Decimal(15,2),ROUND((a.Size-FILEPROPERTY(a.Name,'SpaceUsed'))/128.000,2)) AS [Available Space (MB)]
    
    FROM dbo.sysfiles a (NOLOCK)

SHARE:
+ Post New Thread

Similar Threads

  1. RM CC3 Log Files
    By soapyfish in forum Windows Server 2000/2003
    Replies: 11
    Last Post: 23rd June 2011, 01:07 PM
  2. SCCM OSD Log Files
    By broon in forum O/S Deployment
    Replies: 1
    Last Post: 22nd March 2011, 09:34 AM
  3. Flushing NTFS log files
    By nicholab in forum O/S Deployment
    Replies: 2
    Last Post: 11th January 2010, 09:19 AM
  4. Constant corruption of system MSSQL 2005 files
    By googlemad in forum Windows
    Replies: 6
    Last Post: 1st October 2009, 04:57 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •