How to fix The transaction log for database is full due to 'LOG_BACKUP'.?

 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/

Comentários

Mensagens populares deste blogue

DNS Bind Records for Office365

Categorias de Artigos

Bind DNS records for Google Apps