Printable View
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. :)