[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

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

Posted on 2012-09-04
5
Medium Priority
?
861 Views
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!!!
0
Comment
Question by:CTSFlorida
  • 3
  • 2
5 Comments
 
LVL 32

Assisted Solution

by:Ephraim Wangoya
Ephraim Wangoya earned 1500 total points
ID: 38364736
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
0
 

Author Comment

by:CTSFlorida
ID: 38364807
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!
0
 
LVL 32

Assisted Solution

by:Ephraim Wangoya
Ephraim Wangoya earned 1500 total points
ID: 38364846
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
0
 

Accepted Solution

by:
CTSFlorida earned 0 total points
ID: 38364895
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!
0
 

Author Closing Comment

by:CTSFlorida
ID: 38872811
Found the culprit!
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
Desired Skill Set for Microsoft Dynamics CRM Technical Resources – Part I
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Suggested Courses

873 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