There are some common reasons why a transaction log might not shrink when you use the DBCC SHRINKFILE or DBCC SHRINKDATABASE command. The SQL Server Books Online topics “DBCC SHRINKFILE” and “DBCC SHRINKDATABASE” provide detailed information, but a brief summary follows.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help