Need to create full database backup and transaction log backup on primary server to shrink the log file. The replica server log file will automatically shrink.

Might need to backup the transaction log a couple of times and wait a while before the log file will automatically shrink.

Sources:

https://dba.stackexchange.com/questions/114787/shrink-database-in-always-on-availability

https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-shrinkfile-transact-sql?view=sql-server-ver15

Last modified: August 13, 2020

Author

Comments

Write a Reply or Comment