Wednesday, March 21, 2012

LogScan in progress

Hello,
We have a mixed replication environment with SQL Server transactional
replication and Datamirror replication (with DB2). Yesterday we upgraded to
SQL Server 2005 and the transactional replication does not work.
The log reader message is "Logscan in progress. Approximately 4254920 log
records scanned in pass # 1, elapsed time 7620 (ms).". The Subscription
Watcher tells that all subscriptions are uninitialized. But actually, I have
not subscription to initialize (there are Datamirror). And, in any case, I
cannot reinitialize the subscription because the initial synchronization was
made manually.
Now, all pending changes are in the transaction log of the publisher database.
What can I do? Is to drop and recreate the publication the only way to solve
this issue?
Thank you in advanced,
qwalgrande
You need to contact DataMirror to learn how to make their product work with
SQL Server 2005.
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
"qwalgrande" <qwalgrande*nospam*@.yahoo.es> wrote in message
news:19C4184F-C544-43A3-B6AD-74E170047129@.microsoft.com...
> Hello,
> We have a mixed replication environment with SQL Server transactional
> replication and Datamirror replication (with DB2). Yesterday we upgraded
> to
> SQL Server 2005 and the transactional replication does not work.
> The log reader message is "Logscan in progress. Approximately 4254920 log
> records scanned in pass # 1, elapsed time 7620 (ms).". The Subscription
> Watcher tells that all subscriptions are uninitialized. But actually, I
> have
> not subscription to initialize (there are Datamirror). And, in any case, I
> cannot reinitialize the subscription because the initial synchronization
> was
> made manually.
> Now, all pending changes are in the transaction log of the publisher
> database.
> What can I do? Is to drop and recreate the publication the only way to
> solve
> this issue?
> Thank you in advanced,
> --
> qwalgrande

No comments:

Post a Comment