The transaction log for the database is full

sql sql-server sql-server-2008 dynamics-crm

To fix this problem, change Recovery Model to Simple then Shrink Files Log

1. Database Properties > Options > Recovery Model > Simple

2. Database Tasks > Shrink > Files > Log

Done.

Then check your db log file size at Database Properties > Files > Database Files > Path

To check full sql server log: open Log File Viewer at SSMS > Database > Management > SQL Server Logs > Current


I had this error once and it ended up being the server's hard drive that run out of disk space.


Is this a one time script, or regularly occurring job?

In the past, for special projects that temporarily require lots of space for the log file, I created a second log file and made it huge. Once the project is complete we then removed the extra log file.

Related

Setting the Vim background colors
What happens if i return before the end of using statement? Will the dispose be called?
How to select only the first rows for each unique value of a column?
Disable/turn off inherited CSS3 transitions
What's the use of Jade or Handlebars when writing AngularJs apps
Grant execute permission for a user on all stored procedures in database?
How to send a correct authorization header for basic authentication
invalid target release: 1.7
How do I enable TODO/FIXME/XXX task tags in Eclipse?
What is the difference between the states selected, checked and activated in Android?
How to apply a Git patch to a file with a different name and path?
Best practices: throwing exceptions from properties