I have two servers connected over the net using merge replication.
The publisher (and distributor) machine is being replaced by a new faster box. Can I simply backup the database and restore it on the new machine and expect replication to continue as before - or would replication require a whole new snapshot etc?
The database is several gig in size so I would like to avoid starting replication from scratch if at all possible.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed