Friday, March 30, 2012

saving time in snapshot?

We are using SQL 2K with sp4 and using push replication.
if I set up the push replication for the very first time, is there a way to
save the time for the initial snapshot generation of all tables by having the
subcriber database popuated with tables using backup and restore method from
the publishing dataabase? Then, can I make replication think that two
databases are in syn already (which it is) and start replicate changes from
this point on via the log reader?
wingman
Yes - this is referred to as a nosync initialization. Please see this
article for more info:
http://www.replicationanswers.com/No...alizations.asp
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
sql

No comments:

Post a Comment