MS-Sqlserver Replication

Hi

I setup replication in sql server 2008R2, after some time i found the publisher database T-log is growing rapidly and getting space issue message. please explain me how to trouble shoot this issue.

Thx
Naren
knaren1975Asked:
Who is Participating?
 
AnujConnect With a Mentor SQL Server DBACommented:
Did you tired running checkpoint command and shrink the log file?, also you can use the following commands to monitor pending replication details.

sp_replcmds
sp_replcounters
0
 
AnujSQL Server DBACommented:
Which type of replication you are using?
0
 
knaren1975Author Commented:
I am using transactional replication
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
Anthony PerkinsCommented:
When was the last time you backed up your Transaction Log?
0
 
Anthony PerkinsCommented:
If you have backed up your Transaction Log recently, how frequently do you do it?
0
 
knaren1975Author Commented:
we usually backup T-log for every 1 hr.
0
 
Anthony PerkinsCommented:
Have you tried increasing the frequency to say every 30 or 15 minutes.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.