I have a database which had mdf size of 350 MB and ldf size 4.9 GB When i try to shrink the log file it's not shrinking. I know shrinking a database is not good and it should not be done. But still i am trying to do it for shrinking the log file. The recovery model is set to FULL.
Then i followed some steps:
When I run
i found that logsize is 4932 MB and Log space used is 98.76% So large amount of (98%) of log is using now. Then I tried this command
use <databasename> dbcc loginfo
Now almost all VLF has status 2 which means all are in use. then I tried to take log backup. After log backup also shrinking didnt reduce the size. Then i changed recovery model to simple and then tried shrinking.But this also didn't help. Also I checked for open transaction
dbcc opentran (database)
and found that no transaction is open now. So what is making the database which does not allow me to shrink the log size.How can i solve this?