Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

MS-Sqlserver Replication

Posted on 2012-03-26
7
Medium Priority
?
297 Views
Last Modified: 2012-03-28
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
0
Comment
Question by:knaren1975
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
7 Comments
 
LVL 15

Expert Comment

by:Anuj
ID: 37765231
Which type of replication you are using?
0
 

Author Comment

by:knaren1975
ID: 37765254
I am using transactional replication
0
 
LVL 15

Accepted Solution

by:
Anuj earned 2000 total points
ID: 37765350
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 37769566
When was the last time you backed up your Transaction Log?
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 37769567
If you have backed up your Transaction Log recently, how frequently do you do it?
0
 

Author Comment

by:knaren1975
ID: 37770210
we usually backup T-log for every 1 hr.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 37770980
Have you tried increasing the frequency to say every 30 or 15 minutes.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

660 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question