Title: [1-day-delivery] Troubleshoot a Full Transaction Log (SQL Server Error 9002)
Category: 1-day-delivery
Tag(s): SQL Server, Troubleshoot, Transaction Log
Description: You want to troubleshoot and fix a Full Transaction Log (SQL Server Error 9002).
Management
- Fixed-time: 1 working day(s)
- Fixed-scope: 1 database
- Fixed-price: $100
Work Breakdown
- Truncate the Log
- Resolve full disk volume
- Change log size limit or enable Autogrow
Out of Scope
- Root Cause Analysis (RCA)
Deliverable(s)
- Quick fix only
- The transaction log file should have enough free space.
- Also, it should be set to auto grow.
Prerequisite(s)
- Database server access
- Screen sharing, if applicable