Hello,
I am trying to shrink my production log file as its occupying lot of space in L drive. Its in Alwayson setup. two days back i already removed the db from alwayon and made it simple recovery mode and shrinked the log file. Now again the logs were growing. I checked any open transactions. No open transactions. I checked the log_reuse_wait_desc. Its showing aVAILABILITY_REPLICA.
i tried below commands also.
USE[abc]
GO
CHECKPOINT
GO
CHECKPOINT
DBCC SHRINKFILE('abc_log', 1024, TRUNCATEONLY)
go
Took t-log backups also.tried shrinking log files. Nothing helping me to reduce the size. Infact after running the above commands the log space increased surprisingly. .
I can not remove this db from alwayson and make simple ,shrink. Please help me to reduce the log space..
Thanks,