Getting Started with Adobe After Effects - Part 6: Motion Blur

Upload Image Close it
Select File

Learn about SQL Server DBA, SQL Server database performance,SQL Server optimisation,database tuning,t-sql,ssis
Browse by Tags · View All
DBA Scripts 51
performance 37
SQL Server 29
Object Management 24
#SQLServer 24
Backup and Restore 20
Security Management 20
Powershell 17
Indexes 14
DBA 14

Archive · View All
June 2011 38
January 2011 33
May 2011 32
August 2011 27
July 2011 26
January 2012 24
February 2011 19
April 2011 19
March 2011 17
March 2012 17

Jack Vamvas's Blog

Factors that can delay Log Truncation – LOG BACKUP

Mar 12 2012 12:00AM by Jack Vamvas   

When log records remain active for a long time – truncation can be delayed. The delays can cause the transaction logs to fill. This can lead to a Error 9002

 In the Full Recovery mode , a Log Backup  will delete the commited transaction log records. In the Simple Recovery , it’s after a CHECKPOINT.

A Production Server Error Log reported this message.

Error: 9002, Severity: 17, State: 2.
The transaction log for database 'MyDB' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

--I executed a : 
select log_reuse_wait_desc from sys.databases , 

 According to BOL this means:

 “A log backup is required to move the head of the log forward (full or bulk-logged recovery models only).

When the log backup is completed, the head of the log is moved forward, and some log space might become reusable”

 Very straightforward. I completed a Log Backup – and this solved the problem

 How you respond to a Error 9002 depends on the circumstances .  In my case , some very long running transactions caused the log files to grow and fill the disk.  Users were able to read , but any attempt at updates failed.

See Also

SQL Server Transaction Log files - performance myth

Database autogrow and slow database recovery – t-sql Tuesday 21

Republished with author's permission. See the original post here.

Republished from SQL Server DBA [65 clicks].  Read the original version here [32134 clicks].

Jack Vamvas
5 · 26% · 8528


Your Comment

Sign Up or Login to post a comment.

    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]