I have a 225 GB database with a 390 GB log file, which has recently exploded in size. I am trying to reduce it, according to these instructions: https://www.brentozar.com/blitz/transaction-log-larger-than-data-file/
I cannot reduce it in SSMS or by using the DBCC SHRINKFILE command. I tried to wait until it was not in use, and I also tried a registry backup and then ran DBCC SHRINKFILE again, but it was in vain. Any ideas on what I can do?
I saw in this article (https://www.mssqltips.com/sqlservertutorial/3311/how-to-shrink-the-transaction-log/) that it says you could try changing the recovery model to Simple, run the shrink, then change it back to Full, but that seems risky, so be careful to try.
It is also worth noting that my database is duplicated and currently stuck in a suspended state.
I wonder if you could give any advice. We are your typical store without DBA, so I appreciate any suggestions or suggestions from beginners. Thank you!