Hi,
I have both my server at different location with around 4GB of database and
network is poor.
I am trying this feature of SQl 2005 replication which allows initial
snapshot from backup.
I could do it with pubs db but couldn't understand some points. Expert's
advice will be greatly appreciated.
To my understanding , the initial snapshot flows from publisher to
subscriber (corect me if i am wrong). When I create the subscription I have
to add those 3 valuws to the sp_addSubscription :
@sync_type = initialize with backup.
@backupdevicetype = disk
@backupdevicename = path of the backup file(s).
Why this "@backupdevicename" has to be a path on server side and not
subscriber?
If neone could guide me to an article or link where this is nicely
explained, it'll be great.
I am using 'Replication' for the fisrt time, so the question could be stupid.
Thanks.
>> Stay informed about: Initialize from backup files.