+ Post New Thread
Results 1 to 2 of 2
Windows Thread, SQL Server in Technical; On my AV server i have kaspersky installed and this installs sql server 2005. In the C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG ...
  1. #1
    DSapseid's Avatar
    Join Date
    Feb 2007
    Location
    West Sussex
    Posts
    1,152
    Thank Post
    130
    Thanked 54 Times in 47 Posts
    Rep Power
    38

    SQL Server

    On my AV server i have kaspersky installed and this installs sql server 2005. In the C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG folder there is 28gb of log files!!!! I do not need these log files as some of them data back 3/4 months! Can i just delete them or will it have a funny fit??

    File names are SQLDUMP0001.log, SQLDUMP0001.mdmp, SQLDUMP0001.txt and it goes up to SQLDUMP1000!! There are then SQLDMPR0001.log/.mdmp/.txt up to 4500!!

    There is then one file called SQLDUMP10000.txt that is 3gb!! notepad wont open it as its to big

    Reason behing wanting to delete them is the server is a virtual server and the hdd is only 30gb and i cant find a way of increasing it. VMWARE Server (free one)

  2. #2

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    11,204
    Thank Post
    876
    Thanked 2,729 Times in 2,308 Posts
    Blog Entries
    11
    Rep Power
    782
    Not 100% sure about the logs but I would do a dismount/remount + backup of the db using the SQL 2005 managment studio express thing then after stopping the db move the logs away. Restart the DB and it should be all fine as the dismount should have committed all operations and the backup should be good.

    To expand a virtual disk you just need to do this:
    How To Expand An Exisiting Virtual Disk In VMWare Server

    Then use diskpart while in the virtual windows install to expand the NTFS partition inside the larger virtual disk:
    How to extend a data volume in Windows Server 2003, in Windows XP, in Windows 2000, and in Windows Server 2008
    You may need to turn the page file off temporarily to do this if the data is on the system partition. Also if you just use the "extend" command in the above example it will extend to use all possible space

  3. Thanks to SYNACK from:

    Aurora77 (18th May 2009)

SHARE:
+ Post New Thread

Similar Threads

  1. SQL server DBA
    By SpecialAgent in forum Educational IT Jobs
    Replies: 0
    Last Post: 20th November 2008, 03:50 PM
  2. Getting in a muddle with SQL Server
    By sidewinder in forum Windows
    Replies: 1
    Last Post: 17th November 2008, 02:43 PM
  3. SQL Server pricing?
    By pete in forum Windows
    Replies: 9
    Last Post: 21st July 2006, 06:19 AM
  4. SQL Server
    By wesleyw in forum Windows
    Replies: 5
    Last Post: 28th June 2006, 08:42 AM
  5. sql server
    By chrbb in forum Windows
    Replies: 17
    Last Post: 18th January 2006, 11:23 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
  •