November 11, 2002 at 9:54 am
Hi,
is there a way to force the replication without regenerating the snapshot.
ex :
1- create snapshot
2- drop and create remote database
3- apply snapshot
4- drop and create remote database
5- apply snapshot (again)
In step 5 I receive : no replicated transactions available.
If I use the reinitialize methode I have to regenerate the snapshot.
any ideas?
Alain
November 11, 2002 at 1:02 pm
Think I dont understand. For snapshot replication all you have is the snapshot, why wouldnt you want to reinit?
Andy
November 11, 2002 at 2:07 pm
there's 2 jobs in a snapshot replication
1- snapshot agent (which makes the snapshot files) (5min)
2- distribution agent (applies the snapshot files) (30 sec)
the main reason we don't want to reinit the subscriptions is that we don't want to wait 5 minutes for the snapshot agent to recreated the snapshot files.
The snapshot is compose of static files and empty structure that rarely change .
November 11, 2002 at 4:37 pm
You can make it work by setting the subscription option that keeps the snapshot files on disk, then just drop/add back the subscription, data is ready to go. Since you want the same data as before, why not look at just detaching after the first snapshot and making a copy - after that to restore you just drop the existing db, copy the copy of the original mdf and reattach, back in business.
Andy
November 12, 2002 at 2:58 pm
thk Andy
your solution worked perfectly (detach/reattach)
Alain
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply