Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Force snapshot replication
Message
General information
Forum:
Microsoft SQL Server
Category:
Replication
Miscellaneous
Thread ID:
00721032
Message ID:
00721849
Views:
8
This message has been marked as the solution to the initial question of the thread.
i've found a work around
1 - create a database (db1)
2 - detach db1
3 - copy db1's mdf and ldf to remote server
4 - reattach db1

it take same amount of time but you can do it over (repeat #3-4) and over and over and....

Alain


>I'm almost not surprised.
>
>-Mike
>
>>yes you can manually sync, but I was unable to sync twice in a row without regenerating the snapshot
>>
>>>I thought you could specify that the subscriber would be manually sync'ed.
>>>
>>>-Mike
>>>
>>>>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
Analystik Team
1430 Belanger
Montreal (Quebec)
Canada
(514) 278-2727
analyste@analystik.ca
Previous
Reply
Map
View

Click here to load this message in the networking platform