Failed to shrink transaction log file size (.ldf)

Step 1 - Connect to Database use Microsoft SQL Server Management Studio.

Please refer How to Connect to Database use Microsoft SQL Server Management Studio

Step 2 - Start a new Query

Copy and Paste the following SQL Script into the New Query

SELECT name,log_reuse_wait_desc FROM SYS.DATABASES

Step 3 - Click Execute

Step 4 - If the result of your database’s name is REPLICATION then continue below steps else contact QNE Support Team

Step 5 - Start a new Query

Step 6 - Copy and Paste the following SQL Script into the New Query

EXEC sp_removedbreplication 'SampleDB'----- Change SampleDB to your database name

GO

Step 7 -  When result shown ‘Command(s) completed successfully.’, then repeat steps to shrink transaction log file size.

Please refer How to Shrink Database Transaction Log