Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
luke29
Starting Member
2 Posts |
 Posted - 2007-10-06 : 22:03:20
|
| I am setting up Merge replication with one subscriber that will only be merged one time daily. What is recommended to setup a backup and restore for the publisher, distributor and subscriber? Also would it be necessary to have the Piblisher, distributor and subscriber off line during the backup? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-07 : 00:07:51
|
| Replication shouldn't affect backup schedule, and don't have to stop replication to make backup. |
 |
|
|
luke29
Starting Member
2 Posts |
Posted - 2007-10-07 : 15:38:52
|
| If it is necessary to restore the Publisher database. How do you get the subscriber in synch with the publisher?If the publisher will have changes applied to the published tables regularly. What is the best way to apply changes to published tables? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-07 : 21:08:03
|
| Depends on one-way or two-way replication. For change, do you mean schema change or data change? |
|
|
|
|
|
|
Merge replication backup and recovery