Automatically create a backup of the primary database and restore it to the secondary server , creating the secondary database if necessary 自动创建主数据库备份,可以在需要时将其还原到辅助服务器,以创建辅助数据库。
Clients that were accessing the primary database will be automatically redirected to the secondary database , without any application modifications 访问主数据库的客户将自动转向备用数据库,而不必对应用程序作任何修改。
A failure on the primary database can result in the loss of data that has not yet been backed up or for backups that are lost during the failure 主数据库上的失败可能导致丢失尚未备份的数据或失败期间所丢失备份的数据。
The first time you want to fail over to the secondary database and make it your new primary database , there is a series of steps you must take 当初次将故障转移到辅助数据库并将其用作新的主数据库时,必须执行一系列步骤。
On your secondary database the database you want to be the new primary , configure log shipping using sql server management studio 使用sql server management studio在辅助数据库(要用作新的主数据库的数据库)上配置日志传送。
If the original primary server instance is not damaged , back up the tail of the transaction log of the primary database using with norecovery 如果原始主服务器实例没有损坏,则请使用with norecovery备份主数据库的事务日志尾部。
The transaction log shipping interface in sql server management studio supports only one primary database per log shipping configuration Sql server management studio中的事务日志传送接口对于每个日志传送配置仅支持一个主数据库。
Typically , the primary and secondary databases are unsynchronized , because the primary database continues to be updated after its latest backup job 通常,主数据库与辅助数据库不同步,因为主数据库在其最新的备份作业后会继续更新。