SQL Server 恢复模式影响事务日志磁盘空间要求 (1001046)-HQY 一个和谐有爱的空间

08

2019
09
14:35:47

SQL Server 恢复模式影响事务日志磁盘空间要求 (1001046)

Last Updated:

11/9/2014

Categories: Informational

Details

免责声明：本文为 vmware.com/s/article/1001046" target="_blank" data-aura-rendered-by="11:132;a" name="&lpos=content : 11" style="box-sizing: border-box; background-color: transparent; color: rgb(51, 102, 204); text-decoration-line: none; transition: color 0.1s linear 0s; cursor: pointer;">SQL Server Recovery Model Affects Transaction Log Disk Space Requirements (1001046) 的翻译版本。尽管我们会不断努力为本文提供最佳翻译版本，但本地化的内容可能会过时。有关最新内容，请参见英文版本。

许多客户选择使用 Microsoft SQL Server 数据库部署 vCenter Server。SQL Server 让管理员可以选择恢复模式，这是确定事务日志磁盘空间要求的主要因素。如果不执行相应的数据库维护，则默认使用完整的恢复模式且可能会占用所有可用的磁盘空间。

注意：此问题还会影响提供的 vCloud Director 数据库和解决方案是否适用。

null

Solution

对于未打算调度数据库事务日志的定期备份的站点，VMware 建议将 vCenter Server 数据库设置为简单恢复模式。

有关详细信息，请参见 Microsoft SQL Server 联机丛书和以下 Microsoft Web 资源：

Related Information

SQL Server Recovery Model Affects Transaction Log Disk Space Requirements

Request a Product Feature

To request a new product feature, please contact your VMware representative.

To view or change the recovery model of a database

After connecting to the appropriate instance of the Microsoft SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree.
Expand Databases, and, depending on the database, either select a user database or expand System Databases and select a system database.
Right-click the database, and then click Properties, which opens the Database Properties dialog box.
In the Select a Page pane, click Options.
The current recovery model is displayed in the Recovery model list box.
Optionally, to change the recovery model select a different model list. The choices are Full, Bulk-logged, or Simple.