November 6, 2009 at 11:35 am
Suppose a remote distributor is used to create a snapshot on a different server.
Rather than use the default local folder on the remote distributor, the snapshot is required to be placed on the original source server. The UNC of the source server is used as the location of the generated snapshot.
Box 1 -> Source DB
Box 2 -> Remote distributor
Is the data from the source DB copied from box 1 to the distributor (box 2), and then copied back to the source DB? Or is the snapshot agent clever enough to realize the source and destination of the snapshot is on the same machine, and can therefore be done locally?
November 6, 2009 at 12:21 pm
Interesting question that I would try at my SQL Lab @ Home and update here, cannot test it in my work location.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply