Home > Backend Development > PHP Tutorial > Why is the transaction log filling up? _PHP Tutorial

Why is the transaction log filling up? _PHP Tutorial

WBOY
Release: 2016-07-13 17:01:13
Original
1065 people have browsed it

The SQL Server transaction log may fill up, preventing subsequent database operations, including UPDATE, DELETE, INSERT, and CHECKPOINT.
Transaction log filling will cause 1105 error:
Can't allocate space for object syslogs in database dbname because
the logsegment is full.
If you ran out of space in syslogs, dump
the transaction log.
Otherwise use ALTER DATABASE or
sp_extendsegment to increase the size of the segment.
This phenomenon may occur in any database, including Master and TempDB. Some unforeseen factors may consume log space.
For example:
A large transaction, especially batch data updates, insertions or deletions.
An uncommitted transaction.
The checkpoint handler requires too much bandwidth for truncation.
Exceeding the threshold when truncation
The result of the interaction of the above conditions.
The marked transaction for publishing was not read by the log reader

www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/631171.htmlTechArticleSQL Server transaction log may fill up, which will prevent subsequent database operations, including UPDATE, DELETE, INSERT and CHECKPOINT. The transaction log filling up will result in 1105 error: Can't allo...
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template