27sql管理2.pptVIP

Module 3: 管理数据库文件 概述 数据结构介绍 创建数据库 管理数据库 数据库文件和日志的位置 使用基于硬件的RAID优化数据库 使用带RAID系统的文件组来优化数据库 容量设计 数据结构介绍 数据如何存储 事务 事务日志如何工作 数据如何存储 创建数据库 在创建数据库时发生了什么 指定创建数据库时的选项 在创建数据库后改变选项 查看数据库属性 在创建数据库时发生了什么 Creates a Data File and a Transaction Log Requires That the Owner and Creator Have Permission to the master Database Allows You to Define: The name of the database The properties of the database The location of the database files 指定创建数据库时的选项 Primary File Secondary Files Transaction Log File Name and Location Size File Growth Maximum Size Collation 在创建数据库后改变选项 查看数据库属性 Use SQL Server Enterprise Manager Use SQL Query Analyzer System functions System stored procedures (sp_helpdb or sp_spaceused) DBCC statements (DBCC SQLPERF (LOGSPACE)) 管理数据库 管理数据和日志文件增长 自动压缩数据库或数据库文件 手动压缩数据库或数据库文件 删除数据库 管理数据和日志文件增长 Using Automatic File Growth Specify space allocated, maximum size, and growth increment of each file Optimize performance by allocating sufficient space, setting maximum size, and setting growth increments Manually Expanding Data and Transaction Log Files Determining Whether to Expand Files Automatically or Manually Creating Secondary Data and Transaction Log Files 自动压缩数据库或数据库文件 Enabling Shrinking to Occur Automatically Specifying the autoshrink option in SQL?Server Enterprise Manager Executing the ALTER DATABASE AUTO_SHRINK statement Executing the sp_dboption system stored procedure SQL Server Activities During Auto Shrink Shrinks data and transaction log files when more than 25 percent of the file contains unused space Performs shrinking in the background and does not affect user activity 手动压缩数据库或数据库文件 Methods of Shrinking Shrinking a Database and Data Files Shrinking Transaction Log Files Shrinks inactive portions of the transaction log that are larger than the desired size If that is not enough to reduce to the desired size, SQL?Server returns a message and notifies you what to perform Configuring Shrink Database Options 删除数据库 Methods of Deleting a Database Restric