Out of disk space on CRM 2011 SQL Server

(0) Share

Report

Posted on by Community Member

In dire need of help! My CRM2011 SQL server is down to 8GB of Free Space. I have cleaned out all the old workflows, delete all the audit logs, and cleaned out my hard drive. DB Total Space 203GB, Data File Space 5GB and Transaction LOG 197GB. How can I recover some room?

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Adrian Begovich 1,027 Moderator on at

Like (0)

Report

Hi garabad,

You can either increase the amount of space in your SQL Server, or you can delete things to free up some space. I do not recommend deleting the data in your database, so your best bet is to delete old log files.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Adrian,

Thank you for your response. Can you suggest where I might start looking? I have gotten everywhere I can think of.

Was this reply helpful? Yes No
Suggested answer

Adrian Begovich 1,027 Moderator on at

Like (0)

Report

Hi garabad,

I would start looking in the areas that are used regularly. You can always use a disk space analyzer to find the files taking up the most space, if manually searching takes too much time. Here is a recent article that covers some free disk space analyzer options.

Was this reply helpful? Yes No
Suggested answer

Michel van den Brink 4,697 on at

Like (0)

Report

Hello garabed,

Your transaction log is pretty big - I don't think you need quite that much.

Take a look at this article on how to change the size of your transaction log:

docs.microsoft.com/.../manage-the-size-of-the-transaction-log-file

These are some serious database settings to work with though, there is a possibility to break things, please make sure to follow Microsoft's instructions and recommendations carefully!

Was this reply helpful? Yes No
Aric Levin - MVP 30,190 Moderator on at

Like (0)

Report

Is this is a VM or physical machine?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

It is a physical machine.

Was this reply helpful? Yes No
Aric Levin - MVP 30,190 Moderator on at

Like (0)

Report

In that case, follow the instructions from the link in Michel's post.

You need to reduce your transaction log file.

Make sure you have a backup before starting this.

Was this reply helpful? Yes No