SQL server is eating up valuable space, running out...

Posted on 2012-09-04
Last Modified: 2013-02-10
ok, so I have a vm that is running SQL 2008. Initially, i gave it maybe 50GB. After a while I noticed that it was filling up in a hurry. So, i expanded the disk space to 80GB. However, today I noticed that it only has 2GB left. What in the world.......?

I can hardly imagine that windows update or the SQL DB could be causing this. I mean, the DB is nearly static and windows update couldn't possibly be eating up all that space. What gives? Any ideas on how to fix/control this issue?

Thank you in advance!!!
Question by:CTSFlorida
    LVL 32

    Assisted Solution

    Have you checked the transaction log of your database?
    That can quickly grow out of hand if not managed properly.

    If thats the case, try running frequent backups of the transaction log or change your database recovery model to SIMPLE

    You may need to do an initial shrink of the log file once you take the backup

    Author Comment

    Ok, so I am looking at the transaction logs. I see the current and also 6 archives. I am still an amateur when it comes to sql.... do I need all those archives? can I find out how much disk space they are taking up?

    I really appreciate the advice!
    LVL 32

    Assisted Solution

    Just got to the location on disk where they reside and take a look at the file size.

    If they are old backups, you may need to move them to another storage device, you can check with your admin if they are really database backups and decide what to do with them. It all depends on your backup and restore strategy

    Accepted Solution

    OK, I think I found the culprit!!!

    C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\LogFiles

    This folder is filled with log files and minidump files. the total size is about 50GB.....!!

    So, how should I proceed? Can I delete these dump files? do I need them? and what about the log files? Remember, I am looking directly in the actual folder and could easily reclaim space if i don't desperately need these files.

    Thanks again!

    Author Closing Comment

    Found the culprit!

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    On Sep 22nd 2014 Microsoft released Update Rollup 1 for Microsoft Dynamics CRM 2013 Service Pack 1 and back in July Update Rollup 3 was released.  So we now have:   Update Rollup 1Update Rollup 2Update Rollup 3Service Pack 1Update Rollup 1 for S…
    Automatically creating a Trello card using data from a Microsoft Dynamics CRM record turned out to be an easy project that yielded great results.  Here's how I did this for an internal team at General Code.
    This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…
    This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now