The Blog

Transaction log is full due to LOG_BACKUP

Yesterday, when I was building a large DB from scratch I got an error saying:

Transaction Log for 'Database' is full due to LOG_BACKUP

1	Transaction Log for 'Database' is full due to LOG_BACKUP

Running this simple query solved the issue:

ALTER DATABASE MyDB SET RECOVERY SIMPLE;

1	ALTER DATABASE MyDB SET RECOVERY SIMPLE;