Question

Failed to truncate SQL server transaction logs


Userlevel 1

I know this question has been mentioned several times on various boards, but I have not found one specifically for SQL Express.

Anyone have an idea?

Unable to truncate Microsoft SQL Server transaction logs. Details: Failed to process 'TruncateSQLLog' command.
Failed to truncate SQL server transaction logs for instances:  SQLEXPRESS. See guest helper log.

 

This is one of the errors in the log:


1/30/2023 9:06:49 AM   2772                                  Database found: DBName. Recovery model: 1. Is readonly: false. State: 0.
1/30/2023 9:06:49 AM   2772  WARN                            Cannot truncate SQL logs for database: IncuitySample.     Code = 0x80040e14
1/30/2023 9:06:49 AM   2772  WARN                                Code meaning = IDispatch error #3092
1/30/2023 9:06:49 AM   2772  WARN                                Source = Microsoft OLE DB Driver for SQL Server
1/30/2023 9:06:49 AM   2772  WARN                                Description = The server principal "NT AUTHORITY\SYSTEM" is not able to access the database "IncuitySample" under the current security context.
1/30/2023 9:06:49 AM   2772  WARN                            No OLE DB Error Information found: hr = 0x80004005
1/30/2023 9:06:49 AM   2772                                  Skipping database: AcdStorage
1/30/2023 9:06:49 AM   2772                                  Skipping database: DBName
1/30/2023 9:06:49 AM   2772                                  Skipping database: DBNameDiagnostics
1/30/2023 9:06:49 AM   2772                              Truncating database logs (SQL instance: SQLEXPRESS). User: NT AUTHORITY\SYSTEM.. Ok.


3 comments

Userlevel 7
Badge +20

IncuitySample Likely has strict security permissions, have you confirmed NT Authority\SYSTEM is allowed to read the database and perform truncation?

Userlevel 1

ok, this will be a stupid answer, but how to I verify this in SQLExpress?

Userlevel 7
Badge +20

ok, this will be a stupid answer, but how to I verify this in SQLExpress?

You can install SQL management studio and connect to your SQL Express instance to check. 👍

Comment