all groups > sql server replication > august 2007 >
You're in the

sql server replication

group:

Alternatives to Reinitialize SQL 2005 Trans rep?



Alternatives to Reinitialize SQL 2005 Trans rep? JR
8/9/2007 3:28:40 PM
sql server replication: I need to reinitialize an existing transactional replication set up
(SQL 2005 set up with gui, used a snapshot to initialize) it was
running fine up til now, both databases are in sync, but now it's
saying it needs to reinitialize. Is there a way to do this without
using a snapshot? The databases are close to 1 TB so I'm looking for
alternatives to sending that size snapshot across the network. Thanks!
Re: Alternatives to Reinitialize SQL 2005 Trans rep? Paul Ibison
8/9/2007 10:41:55 PM
You could do a nosync initialization, assuming the data is synchronized :
http://www.replicationanswers.com/NoSyncInitializations.asp
HTH,
Paul Ibison

AddThis Social Bookmark Button