The transaction log for database 'Mydatabase' is full
The transaction log for database ' X' is full . To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases.I have encountered this error today while shrinking the databases to free up some space on the servers. This is command I used: dbcc shrinkdatabase (mydatabase,10) But, as soon I as I ran it, it throws the above error. Solution : The reason for this is that the log file might be FULL. Hence go to Database Properties &g> Options Then set the recovery model to Simple mode and try shrinking the database again. That should work :)