Prev: Cannot insert explicit value for identity column
Next: Merger Replication - SQL2000
From: Darin on 22 Nov 2007 13:48
SQL 2000 on 4 servers (distributor and 3 subscribers).

I deleted about 3.5 million records in a table on the distributor. One
subscriber got all of the deletes fine. The order 2 are getting an
error:

The process is running and is waiting for a response from one of the
backend connections.

I have done a reindex and index defrag on all tables (not system tables,
just our tables) on those 2 machines. We have rebooted all of the
servers. All to no avail.

What are my other options. This is quite iratating.

Darin

*** Sent via Developersdex http://www.developersdex.com ***
From: Darin on 24 Nov 2007 08:30
Since I really don't need to get all of the deletes on the other
subscribers, can I run the following without causing any adverse
effects:

delete from msmerge_tombstone
where tablenick in (select nickname from sysmergearticles where
tablenick=nickname and name='MyTable') and
rowguid not in (select aud_rowguid from MyTable where
aud_rowguid=rowguid)


Darin

*** Sent via Developersdex http://www.developersdex.com ***
From: Hilary Cotter on 26 Nov 2007 09:50
This is really not advisable. It would be best to drop the subscribers, do
the delete and then redeploy them.

--
http://www.zetainteractive.com - Shift Happens!

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
"Darin" <darin_nospam(a)nospamever> wrote in message
news:%23Hoos4pLIHA.2432(a)TK2MSFTNGP04.phx.gbl...
> Since I really don't need to get all of the deletes on the other
> subscribers, can I run the following without causing any adverse
> effects:
>
> delete from msmerge_tombstone
> where tablenick in (select nickname from sysmergearticles where
> tablenick=nickname and name='MyTable') and
> rowguid not in (select aud_rowguid from MyTable where
> aud_rowguid=rowguid)
>
>
> Darin
>
> *** Sent via Developersdex http://www.developersdex.com ***


 | 
Pages: 1
Prev: Cannot insert explicit value for identity column
Next: Merger Replication - SQL2000