I have a database with size 200 GB Total(mdf+ldf) and Log file(ldf) with 50 GB and 99% unallocated space in ldf file i.e. not being used at all.
We had setup log backups for every 5 minutes, so there no problem with ldf file increasing.
We had setup Log shipping on Prod server(Primary) and DR Server(Secondary)
Now i have a question,
- Can i shrink the log file of the database on primary to 1 GB?
- Can i shrink the log file i.e. ldf without changing the recovery model of database to 1 GB?
- Can i shrink the log file without using NOTRUCATE option, if i use ssms wizard to shrink.
- Will shrinking cause for log file to grow more after shrinking?
Expedite answers would be appreciated