transaction logs out of control #344
Unanswered
stuartcporter
asked this question in
Questions & Answers
Replies: 1 comment
-
Could you check if the log backup is backed up? You can see this in the dbo.CommandLog - table. |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
Transaction logs on mirrorred db just keep growing, now at 50gb backup size is 10k! 98% free space
Microsoft SQL Server 2014 (SP2-GDR) (KB4505217) - 12.0.5223.6 (X64)
May 26 2019 20:36:50
Copyright (c) Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.3 (Build 9600: ) (Hypervisor)
Check the header of the stored procedure - this is no version info in the header , just today's date - i think it was installed 2017 ( person who installed is no longer here)
sqlcmd -E -S $(ESCAPE_SQUOTE(SRVR)) -d master -Q "EXECUTE [dbo].[DatabaseBackup] @databases = 'USER_DATABASES', @Directory = N'E:\Backup', @BackupType = 'LOG', @verify = 'Y', @Cleanuptime =168, @Checksum = 'Y', @LogToTable = 'Y', @compress = 'Y'" -b
job completes - but trans log just keep growing
any we missing anything?
Beta Was this translation helpful? Give feedback.
All reactions