See this https://learn.microsoft.com/en-us/sql/relational-databases/logs/troubleshoot-a-full-transaction-log-sql-server-error-9002?view=sql-server-2017#common-reasons-for-a-full-transaction-log Backup copy  https://web.archive.org/web/20240000000000*/https://learn.microsoft.com/en-us/sql/relational-databases/logs/troubleshoot-a-full-transaction-log-sql-server-error-9002?view=sql-server-2017 or quick fix, set db recovery to simple  https://www.mssqltips.com/sqlservertutorial/3311/how-to-shrink-the-transaction-log/ Backup copy https://web.archive.org/web/20240616094706/https://www.mssqltips.com/sqlservertutorial/3311/how-to-shrink-the-transaction-log/