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.