-1
Today when making an Insert in a table the message was presented: The transaction log for database "database name" is full due to "ACTIVE BACKUP OR RESTORE". What is the reason for this message?
1 answer
0
By default, in SQL Server, every database has a file with extension . ldf that stores transaction logs. Depending on the settings it can reach its limit size and start presenting the message you received.
One of the ways to circumvent this situation is to define a self-calification strategy (autogrowth) according to the available space in hd. For this, in Management Studio, just right-click on the bank and select the Properties option. In the menu on the left choose Files (Files) and locate the LOG file of your database. In the Autogrowth/Maxsize column you define your strategy.
If you do not want/can handle these settings you can run the Shrink command according to the article below:
https://www.mssqltips.com/sqlservertutorial/3311/how-to-shrink-the-transaction-log/
In both cases you will need to always keep an eye on the space that the file is occupying.
Browser other questions tagged sql-server
You are not signed in. Login or sign up in order to post.