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?
 
AnujSQL 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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
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.