辅助数据库

• If the primary database is accessible , back up the active transaction log and apply the log backup to the secondary databases
  如果可以访问主数据库，则请备份活动的事务日志，并将日志备份应用到辅助数据库。
• Once the secondary database has been restored , use the management studio log shipping tool to finish setting up log shipping
  一旦还原了辅助数据库，请使用management studio日志传送工具来完成对日志传送的设置。
• After you have followed these initial steps , you will be able to swap roles between the primary database and the secondary database easily
  按照这些初始步骤操作后，就可以轻松地交换主数据库和辅助数据库的角色。
• After you have failed over to a secondary server , you can configure your secondary database to act as a primary database
  交换主服务器和辅助服务器的角色故障转移到辅助服务器后，可以将辅助数据库配置为主数据库。
• Before a failover can occur , a secondary database must be brought fully up - to - date by manually applying any unrestored log backups
  在发生从主数据库到其中一个辅助数据库的故障转移之前，必须手动完全更新辅助数据库。
• Automatically create a backup of the primary database and restore it to the secondary server , creating the secondary database if necessary
  自动创建主数据库备份，可以在需要时将其还原到辅助服务器，以创建辅助数据库。
• 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
  当初次将故障转移到辅助数据库并将其用作新的主数据库时，必须执行一系列步骤。
• The log shipping secondary databases should be on different server instances than either the principal primary server or mirror primary server
  日志传送辅助数据库应该位于非主体/主服务器或非镜像/主服务器的服务器实例上。
• 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在辅助数据库（要用作新的主数据库的数据库）上配置日志传送。
• Typically , the primary and secondary databases are unsynchronized , because the primary database continues to be updated after its latest backup job
  通常，主数据库与辅助数据库不同步，因为主数据库在其最新的备份作业后会继续更新。