<div>
Which type of replication you are using?
</div>


<div>
I am using transactional replication
</div>


<div>
When was the last time you backed up your Transaction Log?
</div>


When was the last time you backed up your Transaction Log?

<div>
If you have backed up your Transaction Log recently, how frequently do you do it?
</div>


If you have backed up your Transaction Log recently, how frequently do you do it?

<div>
we usually backup T-log for every 1 hr.
</div>


<div>
Have you tried increasing the frequency to say every 30 or 15 minutes.
</div>


Have you tried increasing the frequency to say every 30 or 15 minutes.

<div>
<div class="content wysiwyg-content">
Hi <br />
<br />
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.<br />
<br />
Thx<br />
Naren
</div>
</div>


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

MS-Sqlserver Replication

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.