SQL 2005 transaction repl verbose logging location
in [Replication]
|
From: Chuck Lathrope on 14 Feb 2007 16:33 I have primary key duplication issues on brand new snapshot of data, where subscriber is just a read-only reporting server. I am trying to turn on verbose history agent profile, but don't know specifics of doing this. Do I do it on the distribution agent or at the subscriber? Also, where does it store the information? Thanks, Chuck
From: Chuck Lathrope on 14 Feb 2007 16:52 On Wed, 14 Feb 2007 13:33:09 -0800, Chuck Lathrope wrote: > I have primary key duplication issues on brand new snapshot of data, where > subscriber is just a read-only reporting server. I am trying to turn on > verbose history agent profile, but don't know specifics of doing this. Do I > do it on the distribution agent or at the subscriber? Also, where does it > store the information? > > Thanks, > Chuck I found this nice post: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1198133&SiteID=1 which was same issue I was having...
From: Hilary Cotter on 14 Feb 2007 17:26 In the future this is a good article on how to enable this. http://support.microsoft.com/kb/312292 -- Hilary Cotter Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com "Chuck Lathrope" <computerguy_chuck(a)hotmail.com> wrote in message news:150t3cmvxgxb5$.1qai2jtvugwco.dlg(a)40tude.net... >I have primary key duplication issues on brand new snapshot of data, where > subscriber is just a read-only reporting server. I am trying to turn on > verbose history agent profile, but don't know specifics of doing this. Do > I > do it on the distribution agent or at the subscriber? Also, where does it > store the information? > > Thanks, > Chuck
From: Chuck Lathrope on 15 Feb 2007 13:37 On Wed, 14 Feb 2007 13:52:41 -0800, Chuck Lathrope wrote: > From: Chuck Lathrope <computerguy_chuck(a)hotmail.com> > Subject: Re: SQL 2005 transaction repl verbose logging location > User-Agent: 40tude_Dialog/2.0.15.1 > MIME-Version: 1.0 > Content-Type: text/plain; charset="us-ascii" > Content-Transfer-Encoding: 7bit > Reply-To: computerguy_chuck(a)fixme.hotmail.com > References: <150t3cmvxgxb5$.1qai2jtvugwco.dlg(a)40tude.net> > Date: Wed, 14 Feb 2007 13:52:41 -0800 > Message-ID: <uai8v6d8g2zx.kc8adc64ogq3$.dlg(a)40tude.net> > Newsgroups: microsoft.public.sqlserver.replication > NNTP-Posting-Host: 63.251.174.3 > Path: TK2MSFTNGP01.phx.gbl!TK2MSFTNGP02.phx.gbl > Lines: 1 > Xref: TK2MSFTNGP01.phx.gbl microsoft.public.sqlserver.replication:78752 > > On Wed, 14 Feb 2007 13:33:09 -0800, Chuck Lathrope wrote: > >> I have primary key duplication issues on brand new snapshot of data, where >> subscriber is just a read-only reporting server. I am trying to turn on >> verbose history agent profile, but don't know specifics of doing this. Do I >> do it on the distribution agent or at the subscriber? Also, where does it >> store the information? >> >> Thanks, >> Chuck > > I found this nice post: > http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1198133&SiteID=1 > which was same issue I was having... Ok, I enabled logging, but it isn't telling me anything more than I already know - data is somehow being duplicated. I have checked all the subscriptions and there isn't any duplication. The box is a reporting server, so there shouldn't be any inserts to the data. I have completely deleted the subscription and tried again, made sure compatibility mode was at 90. This was working just fine, then one day it just turned south and I turned on ignore errors, then users started complaining that data was missing. Any thoughts on how to troubleshoot from here? Thanks, Chuck Lathrope
From: Raymond Mak [MSFT] on 15 Feb 2007 14:02
Chuck, I've got a couple of questions for you: 1) Did you get the uniqueness violation during the initial bulk-load at the subscriber? (Sounds like it but I want to make sure) 2) Did you start off with an empty subscriber database or did you use "drop" as the pre-creation command for your articles? -Raymond "Chuck Lathrope" <computerguy_chuck(a)hotmail.com> wrote in message news:150t3cmvxgxb5$.1qai2jtvugwco.dlg(a)40tude.net... >I have primary key duplication issues on brand new snapshot of data, where > subscriber is just a read-only reporting server. I am trying to turn on > verbose history agent profile, but don't know specifics of doing this. Do > I > do it on the distribution agent or at the subscriber? Also, where does it > store the information? > > Thanks, > Chuck |