Replicated databases require special attention with regards to backing up and restoring data 数据库对于复制的数据库,需要特别注意与备份和还原数据有关的信息。
To maintain consistency , changes made to the source database are propagated to the replicated database 为了保持一致,对源数据库所做的更改要传播到复制的数据库中。
You can retain replication settings when restoring a backup of a replicated database from a previous version 从早期版本还原复制数据库的备份时,可以保留复制设置。
When you attach a replicated database that was copied instead of being detached , consider the following 当您附加已复制的数据库而不是分离的数据库时,请注意以下事项:
Because a replicated database cannot be detached , replication had to be removed from these databases first 因为无法分离复制的数据库,所以必须首先从这些数据库中删除复制。
Replication supports restoring replicated databases to the same server and database from which the backup was created 复制支持将复制的数据库还原到从中创建备份的同一服务器和数据库。
The following questions and answers provide guidance on a variety of tasks faced by administrators of replicated databases 下列问题和解答就复制数据库管理员所面临的多种任务提供指导。
If you restore a backup of a replicated database to another server or database , replication settings cannot be preserved 如果将复制数据库的备份还原到其他服务器或数据库,则无法保留复制设置。
Details considerations for backing up and restoring replicated databases , with strategies for each type of replication 详细说明备份和还原复制的数据库的注意事项,包括针对每种类型复制的策略。
For example , you can monitor a replicated database for stored procedures or other processes that are taking a long time to complete 例如,可以针对存储过程或其他需要花费很长时间完成的过程监视复制的数据库。