单词 | recovery model | ||||||||||||||||
释义 | recovery model
更多释义 收起释义 例句释义: 复原模式,还原模型,复元模式 1. Optionally, back up the reverted database, especially if it uses the full (or bulk-logged) recovery model. 尤其在使用完整(或大容量日志)恢复模式时,可以选择备份已恢复的数据库。 msdn2.microsoft.com 2. Bulk- logged recovery increases performance for bulk operations and is intended to be used as an adjunct to the full recovery model . 大容量日志恢复可提高大容量操作的性能,并可用作完整恢复模式的附加模式。 www.bing.com 3. The appropriate recovery model for a database depends on the availability and recovery requirements of the database. 适合于数据库的恢复模式取决于数据库的可用性和恢复要求。 msdn2.microsoft.com 4. To select the best suited recovery model for a database, consider the recovery goals and requirements for the database. 若要为数据库选择最合适的恢复模式,必须考虑该数据库的恢复目标和要求。 msdn2.microsoft.com 5. To use database mirroring on a database, the full recovery model is always required. 若要在数据库中使用数据库镜像,始终需要完整恢复模式。 technet.microsoft.com 6. For a database that uses full recovery, switching to the bulk-logged recovery model temporarily for bulk operations improves performance. 对于使用完整恢复的数据库,临时切换到大容量日志恢复模式能够提高大容量操作的性能。 msdn2.microsoft.com 7. Under the full recovery model, you must back up the transaction log, regardless of the rest of your backup strategy. 在完整恢复模式下,必须备份事务日志,不用考虑备份策略的其余部分。 msdn2.microsoft.com 8. Under the simple recovery model, the database cannot be restored to a specific point in time within a specific backup. 在简单恢复模式下,数据库不能还原到特定备份中的特定时间点。 technet.microsoft.com 9. This section summarizes the recommendations for what recovery model to use with each of the system databases. 本节概述了对每个系统数据库所用恢复模式的建议。 technet.microsoft.com 10. If the database uses the full or bulk-logged recovery model, the log backups taken since the most recent differential database backup. 如果数据库使用完整或大容量日志恢复模式,则从最近的差异数据库备份开始进行日志备份。 msdn2.microsoft.com 1. Transactional replication tracks changes by marking the transaction log, but this marking process is not affected by the recovery model. 事务复制通过标记事务日志来跟踪更改,但此标记过程不受恢复模式影响。 msdn2.microsoft.com 2. For more information about how the recovery model affects logging of index operations, see Choosing a Recovery Model for Index Operations. 有关恢复模式如何影响索引操作日志记录的详细信息,请参阅为索引操作选择恢复模式。 msdn2.microsoft.com 3. The simple recovery model is required; therefore, tempdb log space is always automatically reclaimed. 需要使用简单恢复模式,以便始终自动回收tempdb日志空间。 technet.microsoft.com 4. Based on the effort-recovery model, this study links work-family conflict (WFC) and family-work conflict (FWC) with the concept of recovery. 的基础上,努力恢复模型,本研究的联系与复苏概念工作家庭冲突(WFC)和家庭工作冲突(缠绕壳体)。 www.syyxw.com 5. An alternative discourse that has been developed by service users themselves is that of the recovery model. 这种被服务使用者发明起来的话语被称为“康复模式”。 www.sowosky.com 6. The restore operations that are available for a database depend on its recovery model. 可用于数据库的还原操作取决于所用的恢复模式。 msdn2.microsoft.com 7. The following illustration shows the least complex backup strategy that is possible under the full recovery model . 下图阐释了在完整恢复模式下可能使用的复杂性最小的备份策略。 www.bing.com 8. This topic provides a summation of the basic BACKUP statements for each of the backup types supported by the simple recovery model. 本主题总结了简单恢复模式支持的每种备份类型的基本BACKUP语句。 msdn2.microsoft.com 9. Backup and restore operations occur within the context of a recovery model. 备份和还原操作发生在恢复模式的上下文中。 msdn2.microsoft.com 10. Generally , the bulk- logged recovery model resembles the full recovery model , except that it minimally logs most bulk operations . 如果数据库恢复模式设置为大容量日志记录或简单,则可以对重新生成操作进行最小日志记录。 www.bing.com 1. Under the simple recovery model, this assumes that the data has been changed to read-only since the full backup. 在简单恢复模式下,此备份假定自完整备份之后已经将数据更改为只读。 technet.microsoft.com 2. After changing to the full or bulk- logged recovery model , you should take a new differential base or set of differential bases . 更改到完整或大容量日志恢复模式后,应使用新的差异基准或差异基准集。 www.bing.com 3. The create index operation can be minimally logged if the database recovery model is set to either bulk-logged or simple. 如果数据库恢复模型被设置为大容量日志模型或简单模型,则可以记录最少的创建索引操作。 msdn2.microsoft.com 4. They also speed up the logging of bulk copy operations when a database is using the bulk-logged recovery model. 当数据库使用大容量日志恢复模式时,这些数据结构也可以加快将大容量复制操作记录至日志的速度。 technet.microsoft.com 5. We recommend that you use the full recovery model the rest of the time. 我们建议在其余时间使用完整恢复模式。 msdn2.microsoft.com 6. The simple recovery model is generally appropriate for a test or development database. 事务日志所需的维护取决于数据库的恢复模式。 msdn2.microsoft.com 7. After switching back to the full recovery model, you back up the log again. 切换回完整恢复模式之后,再次备份日志。 msdn2.microsoft.com 8. Under the simple recovery model, this backup type is available only for a database with a read-only filegroup. 在简单恢复模式下,此备份类型只可用于包含只读文件组的数据库。 msdn2.microsoft.com 9. However, a database administrator can break the log chain by changing the recovery model to simple and back to full or bulk-logged. 但是,如果数据库管理员先将恢复模式更改为简单恢复模式,然后再将其更改回完整或大容量日志恢复模式,会使日志链断开。 technet.microsoft.com 10. A recovery model is a database property that controls how the transaction log is managed. 恢复模式是一种数据库属性,用于控制事务日志的管理方式。 msdn2.microsoft.com 1. This recovery model bulk logs most bulk operations. It is intended solely as an adjunct to the full recovery model . 此恢复模式可大容量日志记录大多数大容量操作它只用作完整恢复模式的附加模式。 www.bing.com 2. The example starts with an ALTER DATABASE statement that sets the recovery model to SIMPLE. 此示例以ALTERDATABASE语句开头,该语句将恢复模式设置为SIMPLE。 technet.microsoft.com 3. Added content from former "Identifying Your Recovery Goals and Requirements" and "Selecting a Recovery Model" topics. 合并了以前“确定恢复目标和要求”以及“选择恢复模式”主题中的内容。 msdn2.microsoft.com 4. The databases in a log shipping configuration must use the full recovery model or bulk-logged recovery model. 日志传送配置中的数据库必须使用完整恢复模式或大容量日志恢复模式。 msdn2.microsoft.com 5. The bulk-logged recovery model is intended strictly as an adjunct to the full recovery model. 大容量日志恢复模式旨在严格作为完整恢复模式的附加补充。 msdn2.microsoft.com 6. If you want your new databases to use the simple recovery model, change the recovery model of model to SIMPLE. 若希望新数据库使用简单恢复模式,请将model的恢复模式更改为SIMPLE。 technet.microsoft.com 7. To avoid this situation, before you make the filegroup read-only, switch the database to the full recovery model and back up the log. 若要避免此类情况,请在将文件组设置为只读之前切换到完全恢复模式,并备份日志。 msdn2.microsoft.com 8. before switching to the bulk - logged recovery model , you back up the log. 在切换到大容量日志恢复模式之前,先备份日志。 www.ichacha.net 9. For databases that are using either the full or bulk-logged recovery model, you should back up the transaction log. 对于使用完整恢复模式或大容量日志恢复模式的数据库,应该备份事务日志。 msdn2.microsoft.com 10. If you use the full recovery model, you can switch temporarily to the bulk-logged recovery model before you perform such bulk operations. 如果使用完整恢复模式,则可以在执行此类大容量操作前临时切换到大容量日志恢复模式。 msdn2.microsoft.com 1. The bulk-logged recovery model minimally logs bulk operations, though fully logging other transactions. 大容量日志恢复模式按最小方式记录大容量操作(尽管会完整记录其他事务)。 technet.microsoft.com 2. For more information about in-doubt transactions, see the "Two-Phase Commit" section in Using Marked Transactions (Full Recovery Model). 有关有疑问事务的详细信息,请参阅使用标记的事务(完全恢复模式)中的“两阶段提交”部分。 technet.microsoft.com 3. WRITE updates that insert or append new data are minimally logged if the database recovery model is set to bulk-logged or simple. 如果将数据库恢复模式设置为大容量日志模式或简单模式,则对插入或追加新数据的。 msdn2.microsoft.com 4. Under the bulk-logged recovery model, log backups operate correctly when a database contains bulk-logged changes. 在大容量日志恢复模式下,日志备份在数据库包含大容量日志更改的情况下可以正常运行。 msdn2.microsoft.com 5. Automatic checkpoints truncate the unused section of the transaction log if the database is using the simple recovery model. 如果数据库使用的是简单恢复模式,自动检查点将截断事务日志中没有使用的部分。 msdn2.microsoft.com 6. Therefore, the bulk-logged recovery model is intended only for use during bulk operations that allow for minimal logging. 因此,大容量日志恢复模式仅适合在按最小方式记录大容量操作的时候使用。 msdn2.microsoft.com 7. Much of the description of backup under the full recovery model also applies to the bulk-logged recovery model. 完整恢复模式下有关备份的许多说明也适用于大容量日志恢复模式。 msdn2.microsoft.com 8. Mirroring is implemented on a per-database basis and works only with databases that use the full recovery model. 镜像基于每个数据库实现,并且只适用于使用完整恢复模式的数据库。 msdn2.microsoft.com 9. An adjunct of the full recovery model that permits high- performance bulk copy operations . 是完整恢复模式的附加模式,允许执行高性能的大容量复制操作。 www.bing.com 10. Helps you analyze and refine your data availability requirements and choose a recovery model for each database. 帮助您分析和完善数据可用性要求,并为每个数据库选择恢复模式。 msdn2.microsoft.com 1. The simple recovery model minimizes administrative overhead for the transaction log , because the transaction log is not backed up . 简单恢复模式可最大程度地减少事务日志的管理开销,因为不备份事务日志。 www.bing.com 2. if you switch from the full or bulk - logged recovery model to the simple recovery model , you break the backup log chain. 如果从完整恢复模式或大容量日志恢复模式切换到简单恢复模式,则需要中断备份日志链。 www.ichacha.net 3. After bulk importing the data, switch the recovery model back to the full recovery model. 在大容量导入数据之后,将恢复模式切换回大容量日志恢复模式。 msdn2.microsoft.com 4. Under the full recovery model , differential file backups can use multiple bases , but this can be difficult to manage . 在完整恢复模式下,差异文件备份可以使用多个基准,但这可能难以管理。 www.bing.com 5. Under the simple recovery model, consider scheduling differential backups between full database backups. 在简单恢复模式下,请考虑将差异备份安排在完整数据库备份之间。 msdn2.microsoft.com 6. To ensure that data is not lost, back up all Notification Services databases frequently using the full recovery model. 为确保不丢失数据,请经常使用完全恢复模式备份所有NotificationServices数据库。 msdn2.microsoft.com 7. The exact procedures you use to restore a database depends on the recovery model. 用于还原数据库的准确步骤取决于恢复模式。 msdn2.microsoft.com 8. Incorporated introduction backup types that were under Backup Under the Simple Recovery Model and Backup Under the Full Recovery Model. 合并了以前位于简单恢复模式下的备份和在完整恢复模式下备份中的备份类型简介。 technet.microsoft.com 9. Therefore, under the simple recovery model, the backup intervals should be short enough to prevent the loss of significant amounts of data. 因此,在简单恢复模式下,备份间隔应尽可能短,以防止大量丢失数据。 technet.microsoft.com 10. Use a database recovery model that allows for minimal logging of the index operation. 使用数据库恢复模型,它允许对索引操作做最小的日志记录。 technet.microsoft.com 1. Newly created user databases use the same recovery model as the model database. 新创建的用户数据库与model数据库使用相同的恢复模式。 msdn2.microsoft.com 2. If the database uses the full recovery model, before reverting, you should back up the log. 如果数据库使用完整恢复模式,则在执行恢复之前,应先备份日志。 msdn2.microsoft.com 3. The simple recovery model risks significant work-loss exposure if the database is damaged. 如果数据库损坏,则简单恢复模式将面临极大的工作丢失风险。 technet.microsoft.com 4. Incorporated the introductions to backup types from the Backup Under the Simple Recovery Model and Backup Under the Full Recovery Model. 合并了简单恢复模式下的备份和在完整恢复模式下备份中介绍备份类型的内容。 msdn2.microsoft.com 5. The eight frog mouth facing eight long is a recovery model of the impressive works of art. 那个八只蛤蟆对着八条龙张嘴的复原模型是一件令人印象深刻的艺术品。 www.xiami360.com 6. We recommend switching to the full recovery model before starting an online restore. 建议在启动在线还原之前切换为完整恢复模式。 msdn2.microsoft.com 7. Expanded the discussion of the impact of recovery model on log truncation. 扩展了有关恢复模式对日志截断的影响的讨论。 technet.microsoft.com 8. However, partial backups work on all databases, regardless of recovery model. 但是,无论使用何种恢复模式,部分备份都将作用于所有数据库。 msdn2.microsoft.com 9. For more information about the bulk-logged recovery model, including its restrictions, see Backup Under the Bulk-Logged Recovery Model. 有关大容量日志恢复模式(包括它的限制)的详细信息,请参阅在大容量日志恢复模式下备份。 msdn2.microsoft.com 10. Under the simple recovery model, file backups are essentially restricted to read-only secondary filegroups. 但是,对于简单模型数据库而言,文件备份和文件组备份实质上局限于只读辅助文件组。 msdn2.microsoft.com 1. Added recommendations for unlimited file growth and the SIMPLE recovery model. 添加了关于无限文件增长和SIMPLE恢复模式的建议。 msdn2.microsoft.com 2. In these cases, we recommend that you use the full recovery model. 在这种情况下,我们建议使用完整恢复模式。 msdn2.microsoft.com 3. The full recovery model, which fully logs all transactions, is intended for normal use. 完整恢复模式完整地记录所有事务,适合正常使用。 msdn2.microsoft.com 4. For an introduction to the bulk-logged recovery model, see Backup Under the Bulk-Logged Recovery Model. 有关大容量日志恢复模式的介绍,请参阅在大容量日志恢复模式下备份。 technet.microsoft.com 5. Under this recovery model, most bulk operations are only minimally logged. 在大容量日志恢复模式下,多数大容量操作都进行大容量日志记录。 msdn2.microsoft.com 6. You can perform a differential backup for any recovery model (full, bulk-logged, or simple). 可以执行任意恢复模式(完整、大容量日志或简单)的差异备份。 technet.microsoft.com 7. Under the simple recovery model, file backups are basically restricted to read-only secondary filegroups. 在简单恢复模式下,文件备份基本上仅限于只读辅助文件组。 msdn2.microsoft.com 8. Added information about viewing and changing the recovery model. 添加了有关查看和更改恢复模式的信息。 msdn2.microsoft.com 9. The following example sets the recovery model and data page verification options for the. 示例数据库的恢复模式和数据页面验证选项。 msdn2.microsoft.com 10. Under the simple recovery model, a differential backup can have only one differential base. 在简单恢复模式下,一个差异备份只能有一个差异基准。 msdn2.microsoft.com 1. For the bulk-logged recovery model or full recovery model, a log backup is enough. 对于大容量日志恢复或完全恢复,进行日志备份即可。 msdn2.microsoft.com 2. The simple recovery model minimally logs most bulk operations . 简单恢复模式按最小方式记录大多数大容量操作。 www.bing.com 3. For information about restore restrictions, see Restore Under the Bulk-Logged Recovery Model. 有关还原限制的信息,请参阅在大容量日志恢复模式下进行还原。 msdn2.microsoft.com 4. You also need to consider whether you're using database mirroring, which requires the full recovery model. 您还需要考虑您是否在使用数据库镜像,这要求完全恢复模型。 technet.microsoft.com 5. Under the full or bulk-logged recovery model, restoring log backups is required to reach the desired recovery point. 在完整恢复模式或大容量日志恢复模式下,必须还原日志备份才能到达所需的恢复点。 msdn2.microsoft.com 6. Typically, a database uses the full recovery model or simple recovery model. 通常,数据库使用完整恢复模式或简单恢复模式。 msdn2.microsoft.com 7. Incorporated restrictions that were formerly in Backup Under the Bulk-Logged Recovery Model. 合并了原先在在大容量日志恢复模式下备份部分中指出的限制。 msdn2.microsoft.com 8. We recommend that you minimize your use of the bulk-logged recovery model. 建议尽量减少大容量日志恢复模式的使用。 msdn2.microsoft.com 9. What recovery model is required on a replicated database? 复制数据库需要什么样的恢复模式? msdn2.microsoft.com 10. For more information, see Switching from the Full or Bulk-Logged Recovery Model. 有关详细信息,请参阅从完整恢复模式或大容量日志恢复模式切换。 msdn2.microsoft.com 1. You can perform a database backup for any recovery model (FULL, BULK_LOGGED, or SIMPLE). 可以对任意恢复模式(FULL、BULK_LOGGED或SIMPLE)执行数据库备份。 technet.microsoft.com 2. Lists index operations and the type of logging available for these operations based on the recovery model of the database. 基于数据库的恢复模式列出索引操作以及可用于这些操作的日志记录的类型。 technet.microsoft.com 3. However, switching from the simple recovery model, is unusual. 虽然可以从简单恢复模式进行切换,但通常不建议这样做。 msdn2.microsoft.com 4. That has two files, one secondary filegroup, and one transaction log. The database uses the full recovery model. 以下示例还原一个包含两个文件、一个文件组和一个事务日志的数据库。 msdn2.microsoft.com 5. The reverted database retains the permissions and configuration (such as database owner and recovery model) of the database snapshot. 已恢复的数据库将保留数据库快照的权限和配置(例如,数据库所有者和恢复模式)。 msdn2.microsoft.com 6. Sample database, which uses the simple recovery model by default. 示例数据库,默认情况下,该数据库使用简单恢复模式。 msdn2.microsoft.com 7. The switch to the full or bulk-logged recovery model takes effect only after the first data backup. 到完整恢复模式或大容量日志恢复模式的切换仅在第一个数据备份之后才生效。 msdn2.microsoft.com 8. For information about how to create the marked transactions, see Using Marked Transactions (Full Recovery Model). 有关如何创建标记事务的信息,请参阅使用标记的事务(完全恢复模式)。 msdn2.microsoft.com 9. If you need to remove the log backup chain from a database, switch to the simple recovery model. 如果需要从数据库删除日志备份链,请切换到简单恢复模式。 msdn2.microsoft.com 10. Under the full recovery model or bulk-logged recovery model, you can restore individual databases. 在完整恢复模式或大容量日志恢复模式下,可以还原单个数据库。 msdn2.microsoft.com 1. The simple recovery model never supports page restore. 简单恢复模式从不支持页面还原。 msdn2.microsoft.com 2. Verify that the database uses the full recovery model. 验证数据库是否使用了完整恢复模式。 technet.microsoft.com 3. Verify that the recovery model is either FULL or BULK_LOGGED. 验证恢复模式是FULL还是BULK_LOGGED。 msdn2.microsoft.com 4. If the database uses the simple recovery model, marks for reuse the space that precedes the MinLSN. 如果数据库使用简单恢复模式,则标记在MinLSN前重用的空间。 msdn2.microsoft.com 5. For information about how to mark transactions, see Using Marked Transactions (Full Recovery Model). 有关如何标记事务的信息,请参阅使用标记的事务(完全恢复模式)。 msdn2.microsoft.com 6. If you do not want to take log backups, use the simple recovery model. 如果不想进行日志备份,则请使用简单恢复模式。 msdn2.microsoft.com 7. The simple recovery model is inappropriate for production systems where loss of recent changes is unacceptable. 简单恢复模式并不适合生产系统,因为对生产系统而言,丢失最新的更改是无法接受的。 technet.microsoft.com 8. The transaction log is automatically truncated when the database is using the simple recovery model. 如果数据库使用的是简单恢复模式,事务日志将被自动截断。 msdn2.microsoft.com 9. Example: Piecemeal Restore of Only Some Filegroups Full Recovery Model. 恢复点处于完整恢复模式中的某个时间,如下例所示。 msdn2.microsoft.com 10. After some time, change the recovery model to full. 一段时间后,将恢复模式更改为完整恢复模式。 msdn2.microsoft.com 1. You cannot roll forward across recovery model changes that involve the simple recovery model, because the log chain is broken. 由于日志链已断开,因此无法在涉及简单恢复模式的恢复模式切换中前滚。 technet.microsoft.com 2. Note that under the simple recovery model, the file must belong to a read-only filegroup. 请注意,在简单恢复模式下,此文件必须属于只读文件组。 msdn2.microsoft.com 3. The following illustration shows the easiest backup strategy under the full recovery model. 下图显示了在完整恢复模式下的最简单的备份策略。 technet.microsoft.com 4. Such log backups are larger and take longer to complete than under the full recovery model. 这样的日志备份将更大,而且比在完整恢复模式下需要花费更长的时间来完成。 msdn2.microsoft.com 5. This topic is relevant only for databases that contain multiple filegroups under the full or bulk-load recovery model. 本主题仅适用于完整或大容量恢复模式下的包含多个文件组的数据库。 msdn2.microsoft.com 6. For information about how to switch the recovery model, see Switching from the Full or Bulk-Logged Recovery Model. 有关如何切换恢复模式的信息,请参阅从完整恢复模式或大容量日志恢复模式切换。 msdn2.microsoft.com 7. If a log backup taken under the bulk-logged recovery model contains bulk-logged changes, point-in-time recovery is not allowed. 如果在大容量恢复模式下执行的日志备份包含大容量日志更改,则不允许时点恢复。 technet.microsoft.com 8. The recovery model used by the database. 数据库使用的恢复模式。 msdn2.microsoft.com 9. Under the simple recovery model, differential file backups are enabled only for read-only filegroups. 在简单恢复模式下,仅为只读文件组启用了差异文件备份。 technet.microsoft.com 10. Log backups are unavailable under the simple recovery model. 在简单恢复模式下,不能进行日志备份。 technet.microsoft.com 1. The MyAdvWorks_FullRM database is a copy of AdventureWorks, which uses the simple recovery model. MyAdvWorks_FullRM数据库是AdventureWorks的一个副本,它使用简单恢复模式。 msdn2.microsoft.com 2. Under the full recovery model, all bulk operations are fully logged. 在完整恢复模式下,所有大容量操作都将被完整地记录下来。 msdn2.microsoft.com 3. Use the full recovery model for both databases. 对于这两个数据库,使用完整恢复模式。 technet.microsoft.com 4. For more information, see Backup Under the Full Recovery Model. 有关详细信息,请参阅在完整恢复模式下备份。 technet.microsoft.com 5. The database uses the full recovery model. 数据库使用完整恢复模式。 msdn2.microsoft.com 6. The recovery model is irrelevant. 恢复模式无关紧要。 msdn2.microsoft.com 7. Although BCM pages appear in all databases, they are only relevant when the database is using the bulk-logged recovery model. 尽管所有数据库中都显示BCM页,但只有在数据库使用大容量日志记录恢复模式时,才会与BCM页有关。 technet.microsoft.com 8. For backwards compatibility with earlier versions of Microsoft SQL Server, the recovery model of master can be set to FULL or BULK_LOGGED. 为了向后兼容早期版本的MicrosoftSQLServer,可以将master数据库的恢复模式设置为FULL或BULK_LOGGED。 technet.microsoft.com 9. BCM pages are not relevant in a database that is using the simple recovery model, because no bulk logged operations are logged. 在使用简单恢复模式的数据库中,BCM页是不相关的,因为大容量日志记录操作不记入日志。 technet.microsoft.com 10. If the database is, consider using the full recovery model. 如果数据库会遇到这些情况,请考虑使用完整恢复模式。 msdn2.microsoft.com 1. Because the recovery model has just been changed, the WITH FORMAT option is specified to create a new media set. 由于恢复模式已更改,因此指定了WITHFORMAT选项来创建新的媒体集。 msdn2.microsoft.com 2. Every recovery model lets you back up a whole or partial SQL Server database or individual files or filegroups of the database. 所有的恢复模式都允许您备份完整或部分的SQLServer数据库或数据库的单个文件或文件组。 technet.microsoft.com 3. This is useful to separate the backups under the full recovery model from any previous backups made under the simple recovery model. 这对区分完整恢复模式下的备份与以前在简单恢复模式下创建的备份非常有用。 msdn2.microsoft.com 4. Expanded the discussion of how to manage a switch to and from the simple recovery model. 扩展了有关如何管理到简单恢复模式的切换以及从简单恢复模式的切换的讨论。 msdn2.microsoft.com 5. Under the Simple Recovery Model, file and filegroup backups are available only for read-only filegroups. 在简单恢复模式下,文件和文件组备份只适用于只读文件组。 msdn2.microsoft.com 6. Under the full recovery model, you should schedule frequent log backups. 在完整恢复模式下,应安排经常的日志备份。 msdn2.microsoft.com 7. This is relevant for databases that typically use the full recovery model. 它与通常使用完整恢复模式的数据库相关。 technet.microsoft.com 8. The default recovery model of the model database depends on the edition of SQL Server. model数据库的默认恢复模式取决于SQLServer的版本。 msdn2.microsoft.com 9. Set the recovery model of tempdb to SIMPLE. 将tempdb的恢复模式设置为SIMPLE。 technet.microsoft.com 10. Describes how to perform a complete database restore under the simple recovery model, and includes an example. 说明如何在简单恢复模式下执行完整的数据库还原并包含示例。 msdn2.microsoft.com 1. This topic is relevant for optimizing bulk operations on SQL Server databases that typically use the full recovery model. 本主题适用于对通常使用完整恢复模式的SQLServer数据库进行大容量操作的优化。 msdn2.microsoft.com 2. Unless a backup is running, minimal logging is used under the simple recovery model. 除非执行备份,否则在简单恢复模式下使用最小日志记录。 msdn2.microsoft.com 3. This topic is relevant for SQL Server databases that ordinarily use the full recovery model. 本主题适用于通常使用完整恢复模式的SQLServer数据库。 msdn2.microsoft.com 4. Contains an introduction to the restore scenarios that are available for SQL Server backups under the simple recovery model. 简要介绍简单恢复模式下的SQLServer备份可用的还原方案。 msdn2.microsoft.com 5. Under the full recovery model, you can also restore pages while the database is online. 在完整恢复模式下,您还可以在数据库在线时还原页。 technet.microsoft.com 6. The supported restore scenarios depend on the recovery model of the database and the edition of SQL Server 2005. 支持的还原方案取决于数据库的恢复模式和SQLServer2005的版本。 msdn2.microsoft.com 7. In SQL Server 2005, logging is determined by the recovery model in effect for the database. 在SQLServer2005中,日志记录由数据库的实际恢复模型决定。 msdn2.microsoft.com 8. Under any recovery model, you can restore a file that is offline while the database is online. 在任何恢复模式下,您都可以在数据库在线时还原处于离线状态的文件。 www.kuenglish.info 9. This topic is relevant for SQL Server databases that use the full recovery model. 本主题适用于使用完整恢复模式的SQLServer数据库。 technet.microsoft.com 10. Under the full recovery model, differential file backups are allowed on any filegroup for which you have a differential base. 在完整恢复模式下,允许对具有差异基准的任何文件组进行差异文件备份。 technet.microsoft.com 1. Use the full recovery model and, optionally, also the bulk-logged recovery model if any one of the following is true 如果符合下列任一要求,则使用完整恢复模式(还可以选择使用大容量日志恢复模式) msdn2.microsoft.com 2. For more information about how the recovery model affects logging of index operations, see 有关恢复模式如何影响索引操作日志的详细信息,请参阅 msdn2.microsoft.com 3. Example: Online Restore of a Read-Only File (Simple Recovery Model) 示例:在线还原只读文件(简单恢复模式) technet.microsoft.com 4. Example: Online Restore of a Read-Only File (Full Recovery Model) 示例:在线还原只读文件(完整恢复模式) technet.microsoft.com 5. For more information, see Performing a Complete Database Restore (Full Recovery Model) 有关详细信息,请参阅执行数据库完整还原(完整恢复模式)。 msdn2.microsoft.com 6. Viewing and Changing the Recovery Model of a Database 查看和更改数据库的恢复模式 msdn2.microsoft.com 7. For an introduction to the types of backups that are available under the simple recovery model, see 有关简单恢复模式下可用备份类型的介绍信息,请参阅 msdn2.microsoft.com 8. Planning and Performing Restore Sequences (Full Recovery Model) 计划和执行还原顺序(完整恢复模式) msdn2.microsoft.com 9. Additional Considerations for the Full Recovery Model 完整恢复模式的其他注意事项 msdn2.microsoft.com 10. Performing a Complete Database Restore (Simple Recovery Model) 执行数据库完整还原(简单恢复模式) technet.microsoft.com 1. For more information about selecting the appropriate recovery model, see 有关选择适当恢复模式的详细信息,请参阅 msdn2.microsoft.com 2. Research on Disaster Recovery Model of the Digitized Library 数字化图书馆容灾模型研究 www.ilib.cn 3. Recovery Models for System Databases Switching from the Full or Bulk-Logged Recovery Model 从完整恢复模式或大容量日志恢复模式切换 msdn2.microsoft.com 4. Example: Piecemeal Restore of Database Simple Recovery Model 简单恢复模式对段落还原的影响 msdn2.microsoft.com 5. Choosing the Recovery Model for a Database 选择数据库恢复模式 msdn2.microsoft.com 6. To view or change the recovery model of a database 查看或更改数据库的恢复模式 msdn2.microsoft.com 7. The following operations, which are fully logged under the full recovery model, are minimally logged under bulk-logged recovery model 下列操作在完整恢复模式下完整记录,而在大容量日志恢复模式下按最小方式记录 msdn2.microsoft.com 8. Research on fault-recovery model and scheme in dual-system redundancy router 双冗余结构路由器故障恢复模型与方案研究 www.ilib.cn 9. Copy-only log backups (full recovery model and bulk-logged recovery model only) 仅复制日志备份(仅限于完整恢复模式和大容量日志恢复模式) msdn2.microsoft.com 10. How the Bulk-Logged Recovery Model Works 大容量日志恢复模式的工作原理 msdn2.microsoft.com 1. For more information about bulk-logged recovery model, see Backup Under the Bulk-Logged Recovery Model 有关大容量日志恢复模式的详细信息,请参阅在大容量日志恢复模式下备份 technet.microsoft.com 2. Construction and tactics of service recovery model 服务补救模型的构建及策略 www.ilib.cn 3. Example: Piecemeal Restore of Only Some Filegroups (Simple Recovery Model) 示例:仅对某些文件组进行段落还原(简单恢复模式) technet.microsoft.com 4. For information about what operations are bulk logged under the bulk-logged recovery model, see 有关在大容量日志恢复模式下对哪些操作执行大容量日志记录的信息,请参阅 msdn2.microsoft.com 5. Study on disaster recovery model for information system 信息系统灾难恢复模型研究 www.ilib.cn 6. Database, modify it to use the full recovery model 数据库使用数据库镜像,请改用完整恢复模式 msdn2.microsoft.com 7. Impact of the Recovery Model on Backup and Restore 恢复模式对备份和还原的影响 msdn2.microsoft.com 8. After Switching to the Simple Recovery Model 切换到简单恢复模式之后 msdn2.microsoft.com 9. After Switching from the Simple Recovery Model 从简单模式切换之后 msdn2.microsoft.com 10. To change the default recovery model for new databases, use ALTER DATABASE to change the recovery model of the 若要更改新数据库的默认恢复模式,请使用ALTERDATABASE更改 msdn2.microsoft.com 1. Restore Restrictions Under the Simple Recovery Model 简单恢复模式下的还原限制 msdn2.microsoft.com 2. A Recovery Model of Realtime Main Memory Database 一个支持实时内存数据库的恢复系统 www.ilib.cn 3. For information about how to view the current recovery model of the model database, see 数据库的当前恢复模式的信息,请参阅 msdn2.microsoft.com 4. Switching from the Simple Recovery Model 从简单恢复模式切换 technet.microsoft.com 5. Backup Restrictions Under the Bulk-Logged Recovery Model 大容量日志恢复模式下的备份限制 msdn2.microsoft.com 6. Under the bulk-logged recovery model, the following backup restrictions exist 在大容量日志恢复模式下,存在下列限制 msdn2.microsoft.com 7. Under any recovery model, you can take the database offline by using the following ALTER DATABASE statement 在任何恢复模式下,您都可以使用以下ALTERDATABASE语句使数据库离线 technet.microsoft.com 8. Recovery model for the database 数据库的恢复模式 technet.microsoft.com 9. Restoring Backups Under the Bulk-Logged Recovery Model 在大容量日志恢复模式下还原备份 msdn2.microsoft.com 10. Use the simple recovery model if the following are all true 如果符合下列所有要求,则使用简单恢复模式 msdn2.microsoft.com 1. When to Use the Bulk-Logged Recovery Model 何时使用大容量日志恢复模式 msdn2.microsoft.com 2. When to Use the Simple Recovery Model 何时使用简单恢复模式 msdn2.microsoft.com 3. When to Use the Full Recovery Model 何时使用完整恢复模式 msdn2.microsoft.com 4. Backup Under the Simple Recovery Model 简单恢复模式下的备份 msdn2.microsoft.com 5. How to: View or Change the Recovery Model of a Database SQL Server Management Studio 注意:若要更改新数据库的默认恢复模式,请更改 msdn2.microsoft.com |
||||||||||||||||
随便看 |
|
英汉双解词典包含2704715条英汉词条,基本涵盖了全部常用单词的翻译及用法,是英语学习的有利工具。