Shrink failed for LogFile ‘XYZ’ (Microsoft SQL Server)



Share this article :

Symptom

You wanted to shrink the transaction log files using the SQL Management Studio. Unfortunately, below error message coming out,

Shrink failed for LogFile ‘XYZ’. The transaction log for dataabse ‘XYZ’ is full due to ‘LOG_BACKUP’

Shrink failed for LogFile

Solution

Go to Database Properties (Right click on the database name and select Property). Go to Options and from the right panel, switch the Recovery model to Simple. Now, re-execute the shrinking process.

Database Properties - Recovery Model

Tags:

Related posts

Find Last Database Backup & Log Backup for MSSQL Server
Definition: mdf, ndf & ldf (SQL Server)
Enable & Disable Auto Shrink in MSSQL Server
Restore of database 'SID' failed. Exclusive access could not be obtained because the database is in ...
© 2017 ITsiti. All Rights Reserved
Powered by KEEM