scheduling snapshot and synchronization is missing on the generate scripts

hello all,

i need to bring down the entire replication solution

but just before i do that i need to script. The EM has a generate script feature

but it lacks the schedule for snapshot generation and synchronization

by the way,

whats the fastest way of melting the entire replication solution and

then brinnging them back again.

Can i do replication backup and restore?

regards,

joey

use <published db name>

exec sp_removedbreplication <published db name>

go

use master

sp_dropdistributor 1

go

You can use sp_removedbreplication on the subscriber database as well, and if you have a remote distributor, you can run sp_dropdistributor 1 to remove the distributor.

After that, you can apply your scripts.

sql