Log File full-Troubleshooting

1. Check the log file size by using DBCC sqlperf(logspace), we can increase log size up to 2TB
2. Purging the old files
3. Take a Log Backup if database in full recovery model  i. Backup log dbname to disk =’path’
4. Run the checkpoint if database in simple recovery model
5. Increase the LOG file size or Enable Auto Growth (Make sure it’s not set to Maximum)
6. Add one more T-Log file from  another drive
7. Shrink the file Use dbname Go DBCC shrinkfile (<transactionlogname>,1)
8. Request windows team to add more space
9. If the recovery model is Full change to Simple 10. Find the long running transactions and kill after approval  

No comments:

Post a Comment