-
Transaction Log File Issue
I have one SQL Server holding couple databases. And a maintenance job running every night to backup the log files.
The command like :
BACKUP LOG DB_1 WITH TRUNCATE_ONLY
The server have kept sending error messages those days.
It said the Log file is full. Actually, noone is using those databases.
I need help!
-
Did you check db's log usage? What's db recovery model?
-
The recovery mode for the DB is "FULL".
-
The job also contains DBCC DBREINDEX and UPDATE STATISTICS for each table within the DB. Is that could be the reason making tran log grow?
-
Yes, building index generates logs. By the way, you should do regular log backup for point of time recovery and to truncate log.
-
Thank you for the advices.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|