I work on a SQL Server 2016 Database and in our production environment we have primary SQL server and a fail over SQL server. All the transactions are occurring on the primary SQL server. In primary , i have Full Backup running every day at night and Transaction log backup running every one hour. Transaction replication is enabled in Primary to fail-over server.
In fail over server there i didn't set up full backup and transaction log backup.Recently i got alert that the drive in which LDF file is stored in fail over server is full.
That is when it clicked to me,that in fail-over i am not running regular Full back and Transaction log backup.(Recovery Model is Full Recovery) which is causing LDF file to grow and not truncate.
So i did a full backup of the database and then a transaction log backup ,but the LDF file size is stil the same.So i did a database shrink operation(i know that shrinking is not recommended) but still the LDF file size is same.
How can i reduce the LDF file size? Please help.
