+ Post New Thread
Results 1 to 5 of 5
Windows Server 2000/2003 Thread, MSSQL on Server 2003 R2 in Technical; Morning, I have inherited a Windows Server 2003 R2 which keeps filling. I've tracked it down to this folder; C:\WINDOWS\SYSMSI\SSEE\MSSQL.2005\MSSQL\LOG ...
  1. #1

    Jawloms's Avatar
    Join Date
    Aug 2007
    Posts
    837
    Thank Post
    179
    Thanked 106 Times in 73 Posts
    Rep Power
    186

    MSSQL on Server 2003 R2

    Morning,

    I have inherited a Windows Server 2003 R2 which keeps filling. I've tracked it down to this folder;

    C:\WINDOWS\SYSMSI\SSEE\MSSQL.2005\MSSQL\LOG

    It's generating 18 files a minute (6 logs, 6 minidumps and 6 text files) from about 9am to 5 the following am. I've done some googling and found lots of results about how to stop the ldf growing too big, but none about what to do if it's filling with errors, or more importantly what this folder is actually for! Obviouslt MSSQL, but to do what?

    Any help would be appreciated as at the moment I am just emptying the folder every morning.

    Thank you

    Stuart

  2. #2

    Jawloms's Avatar
    Join Date
    Aug 2007
    Posts
    837
    Thank Post
    179
    Thanked 106 Times in 73 Posts
    Rep Power
    186
    Anyone please?

  3. #3

    AngryTechnician's Avatar
    Join Date
    Oct 2008
    Posts
    3,730
    Thank Post
    698
    Thanked 1,214 Times in 761 Posts
    Rep Power
    395
    This is basically the log folder for the SQL instance itself (not to be confused with transaction logs for the database).

    The files there are not data-critical, so you can safely remove them as you have been doing, but if that many are being generated you have an underlying problem with SQL Server that should not be ignored. Examine the log files to find out what's wrong, as well as the system Event log.

  4. Thanks to AngryTechnician from:

    Jawloms (26th September 2013)

  5. #4

    Jawloms's Avatar
    Join Date
    Aug 2007
    Posts
    837
    Thank Post
    179
    Thanked 106 Times in 73 Posts
    Rep Power
    186
    Quote Originally Posted by AngryTechnician View Post
    This is basically the log folder for the SQL instance itself (not to be confused with transaction logs for the database).

    The files there are not data-critical, so you can safely remove them as you have been doing, but if that many are being generated you have an underlying problem with SQL Server that should not be ignored. Examine the log files to find out what's wrong, as well as the system Event log.
    Thanks for your reply. I've had a look through the log files and I can't see anything obvious in there telling me what's wrong, I haven't checked the event log yet. I know it's the log folder for the SQL instance, but what SQL instance? Why is SQL installed in this server and how do I find out what this instance is used for?

    Stuart

  6. #5

    Join Date
    Apr 2006
    Posts
    390
    Thank Post
    24
    Thanked 95 Times in 61 Posts
    Rep Power
    45
    Never come across it before, but this seems like a good overview: Administering your Windows Internal Database MICROSOFT##SSEE instance (also: Windows Internal Database - Wikipedia, the free encyclopedia).

    As to why it's filling up your hard drive - if it's anything like 'normal' SQL Server you'll have a file called errorlog.x which contains hopefully useful info - find the most recent one, open it in a text editor and start at the bottom and work up.

    Seems odd that the files are created during certain times only - have you got any scheduled things happening that tie in with the activity?



SHARE:
+ Post New Thread

Similar Threads

  1. Issue with Teacher log on XP Workstation on Server 2003 R2 Domain
    By speckytecky in forum Windows Server 2000/2003
    Replies: 9
    Last Post: 3rd March 2011, 11:03 AM
  2. Replies: 4
    Last Post: 25th January 2010, 06:09 AM
  3. Vista on Server 2003 R2
    By rhyds in forum Windows Vista
    Replies: 2
    Last Post: 16th May 2008, 06:55 PM
  4. VPN Setup on Windows 2003 R2 server
    By marvin in forum Windows
    Replies: 11
    Last Post: 13th December 2007, 09:34 AM
  5. Replies: 3
    Last Post: 16th November 2006, 07:35 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
  •