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)
 Replication Data

Author  Topic 

CSK
Constraint Violating Yak Guru

489 Posts

Posted - 2007-01-29 : 13:11:37
Hi all,
Where is the replication log will be stored.My replication is failed due to server down.I have setup as a transaction replication. I just want to know where that log will be availbale.


thanks
krishnakumar

MohammedU
Posting Yak Master

145 Posts

Posted - 2007-01-30 : 01:20:20
What kind of log you are looking for?
If you are looking for error info then right click the distribution/log reader agent click agent history....
If you are looking for transactions to be replicated...I believe they stored in MSrepl_commands table and log will not be trucated until the transactions are replicated...


MohammedU
Go to Top of Page

CSK
Constraint Violating Yak Guru

489 Posts

Posted - 2007-01-30 : 13:57:51
Hi MohammedU, Thanks for your comments , I am very clear about your answer.

Thanks
Krishna
Go to Top of Page
   

- Advertisement -