(DBA TIPS) Maintenance Plan to avoid Transaction log file growth

home
database
view story

2 Kicks

(DBA TIPS) Maintenance Plan to avoid Transaction log file growth(technotes.towardsjob.com)

submitted by nitinkumarbe(175) 2 years, 8 months ago

General problem faced by most the database server is growth in transaction log file. This causes less free memory space on database server. To recover from a situation where the transaction logs grow to an unacceptable limit, you must reduce the size of the transaction logs. To do this, you must truncate the inactive transactions in your transaction log and shrink the transaction log file. Truncate the inactive transactions in your transaction log When the transaction logs grow to an unacceptable limit, you must immediately back up your transaction log file.

add a comment |category: Database |Views: 8
Tweet