December 29, 2016 at 4:49 am
Hi,
I have a transactional replication built in 2008 environment. My Log file size keeps growing and its usage is always 99% and i am not able to shrink the log also. Please help. Thanks in advance!
Chelladurai
December 29, 2016 at 4:58 am
The log file for which database - the publisher or the subscriber? Are all subscribers currently in synch with the publisher? What do you get if you run this?SELECT log_reuse_wait_desc
FROM sys.databases
WHERE name = 'MyDatabase'
John
December 29, 2016 at 5:02 am
LOG_BACKUP - I get this in the query you gave.
And i am sorry that i didnt post my question clear. The log size for Publication database is where i am facing this issue. Replication is fine and the subscriber is in sync.
December 29, 2016 at 5:17 am
haichells (12/29/2016)
LOG_BACKUP - I get this in the query you gave.
There's your answer. Make sure that all databases (replicated or not) that are in Full recovery mode have regular transaction log backups.
John
January 1, 2017 at 9:41 pm
This was removed by the editor as SPAM
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply