Dynamics CRM 2011 500GB SQL Database

0
votes

I installed Dynamics CRM 2011 like 5 month ago and It was working flawlessly , but now I got an error that the server is full of storage I gave the server 1TB of storage. The CRM SQL Database is using 430 GB which is very big for 5 month ! What can be possibly wrong . Auditing is only using 5 GB this is what the auditing page in CRM listed.

Thank You

1
sql-server-2008dynamics-crm-2011dynamics-crmcrmmicrosoft-dynamics
Have you tried this: stackoverflow.com/questions/7071473/… - Daryl
@Daryl yes it didn't resolve my problem - Cham
Did it tell you what database tables were taking up the majority of memory? - Daryl

1 Answers

0
votes

It sounds like your sql log files are really getting big. I suggest youll read about shrinking the sql log files:

http://blogs.technet.com/b/patricg/archive/2007/10/03/sql-server-tips-n-2-best-practices-for-shrinking-t-log-files-and-database-files.aspx