How to check replication status

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Replication (2005)

How to check replication status

Author

Topic

govthamb
Starting Member

27 Posts

Posted - 2009-08-18 : 03:16:55

Hi,

I have a challenge which I am facing in SQL Server 2005 Replication.

I need to check the following:
1. What are the exact records replicated for the past 30 minutes
2. Where to check the error, if any of the agent fails
3. Which data has been transferred from one article to another article from publisher to subsriber
4. How and where to check the error if the Distributor fails

I tried to check in the replication monitor as it is only giving the status of the replication and options like start, stop etc.,

Please suggest me.

Thanks.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-08-18 : 10:16:44

Have you checked Replication Monitor?

N 56°04'39.26"
E 12°55'05.63"

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2009-08-18 : 10:34:09

use distribution;
go
select top 100 * from msrepl_errors order by [time] desc;

suresha_b
Yak Posting Veteran

82 Posts

Posted - 2009-08-21 : 05:14:50

quote:
Originally posted by govthamb

1. What are the exact records replicated for the past 30 minutes
3. Which data has been transferred from one article to another article from publisher to subsriber

Replication is supposed to transfer all the records right? They why checking what data has been transferred?
Do you want to keep log of the records replicated?
IF millions of records are replicated, what will you do with it?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources