Restores the entire database , beginning with a full database backup , which may be followed by restoring a differential database backup and log backups 数据库完整还原还原整个数据库,将从完整数据库备份开始,然后还原差异数据库备份(和日志备份) 。
Immediately after you complete the switch to the full recovery model or bulk - logged recovery model , take a full or differential database backup to start the log chain 从简单恢复模式切换到完整模式之后,建议您:立即执行完整数据库备份或差异数据库备份。
Therefore , for recovery purposes , after using either of these options , immediately execute backup database to take a full or differential database backup 因此,为了进行恢复,使用这些选项中的任一个后,必须立即执行backup database以执行完整或差异数据库备份。
All changes since the most recent database or differential database backup are lost and must be manually reentered . the default recovery model is determined by the recovery model of the 最近的数据库备份或差异数据库备份之后的所有更改都将丢失,必须手动重新输入。
During a full or differential database backup , sql server backs up enough of the transaction log to produce a consistent database when the backup is restored 在进行完整数据库备份或差异数据库备份时, microsoft sql server会备份足够的事务日志,以便在还原备份时生成一个一致的数据库。
This rolls back all transactions that were incomplete when the recovery started and brings the database online . after the database has been recovered , you cannot restore any more backups 如果日志备份丢失或损坏,则可通过创建完整数据库备份或差异数据库备份并备份事务日志来启动新的日志链。
Under the full recovery model , use a combination of database , differential database , and transaction log backups to minimize the number of backups that need to be applied to bring the database to the point of failure 在完整恢复模式下,组合使用数据库备份、差异数据库备份和事务日志备份可以将数据库恢复至故障点所需备份数减到最少。