Failed to shrink transaction log file size (.ldf) : QNE Software Sdn. Bhd.

Failed to shrink transaction log file size (.ldf) Print

Created by: Cheng Kah Poh

Modified on: Fri, 25 Sep, 2020 at 11:51 AM

Step 1 - 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

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

Cheng is the author of this solution article.

Did you find it helpful? Yes No

Failed to shrink transaction log file size (.ldf) Print