asked on

MSSQL Log files taking up 28 GB

Dear Experts,
I was alerted by the users not receiving emails, and when I went into our Exchange server, I realized that C drive was critically full. I started to clean up, after running disk clean up, and doing routine things, I still did not have enough room.
I found out that MSSQL 10_50.SBMONITORING\MSSQL\Log folder was 28GB. I would like to reduce the size of this folder, but not sure if I can just go in and delete files. Some .mdmp files are over 5 years old.
We are using Windows Small BUsiness Server 2011 Standard, and besides Exchange Server 2010, there is a database program on this drive. The data is stored on another drive.
Please advise.

SOLUTION

EugeneZ

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

funwithdotnet

You should do a backup to include the transaction logs. I think they'll automatically shrink after that, in most circumstances.

Good luck!

ASKER CERTIFIED SOLUTION

JesNoFear

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Vitor Montalvão

First lesson:
- Do NOT install user databases in C: drive. It will affect your operating system.

Second lesson:
- When using databases with Full Recovery model you need to schedule regular transaction log backups to truncate the file.

yballan

ASKER

Thank you, Experts, for pointing me tot he right direction!!