I have database in SQL Server, when I create backup the size of backup file is 4 Gb and its data log file shows 136 GB. When I restore the log file size shows 136GB which effect over performance - is there any solution?
Thank you in advance
I googled but did not find solution.
it's generally okay to shrink the transaction log file after taking a full and log backup if it has grown excessively. However, be cautious when shrinking as it can cause fragmentation. It's essential to monitor your database's size regularly and follow best practices to avoid log file growth.
