sending the snapshot to a remote computer -- sql server replication

Lina Manjarres
1/13/2006 5:42:02 AM

Thanks Paul
How can I creat the snapshot to zip it?
I have never done a nosync instalation. Remember that the computers are far
away. Now the data is not identical because there is one computer
sinchronizing.
Regards, Lina

[quoted text, click to view]

Lina Manjarres
1/13/2006 7:46:01 AM

ok. but where is the snapshot file?

Thanks a lot, Lina

[quoted text, click to view]

Lina Manjarres
1/13/2006 8:57:04 AM

Paul, I need the snapshot for a merge replication and this storeprocedure is
for transactional or snapshot replication.

[quoted text, click to view]

Paul Ibison
1/13/2006 9:02:31 AM

Lina,
I'm not too sure of what you need. You mention that you want to send the
snapshot to the remote computer but that the data is already there. If it's
a case of a big snapshot being the issue, then you can create the snapshot,
zip it up, get it onto the remote computer, unzip it then set the subscriber
to access an alternative snapshot location. If the data on the subscriber
and publisher is identical, you could do a nosync initialization and avoid
the need to create the snapshot entirely.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Paul Ibison
1/13/2006 3:35:30 PM

Lina,
to zip it up if it is large (>2GB) use winzip >= 9.0.
Doing a nosync initialization is detailed here:
http://www.replicationanswers.com/NoSyncInitializations.asp
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Paul Ibison
1/13/2006 4:19:49 PM

Lina,
It's a folder in your distribution working folder. Have a look at
sp_browsesnapshotfolder
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Paul Ibison
1/13/2006 5:20:03 PM

Lina,
have a look at the distributor properties, publishers then the elipsis
button. This'll show you what is defined as the snapshot folder.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server replication

sql server replication : sending the snapshot to a remote computer