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
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.
It is a physical machine.
Is this is a VM or physical machine?
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!
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.
Adrian,
Thank you for your response. Can you suggest where I might start looking? I have gotten everywhere I can think of.
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.
#1
André Arnaud de Cal...
292,494
Super User 2025 Season 1
#2
Martin Dráb
231,305
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
