1、創(chuàng)建和管理數(shù)據(jù)庫總括數(shù)據(jù)庫的定義使用文件組數(shù)據(jù)庫的管理如何創(chuàng)建數(shù)據(jù)庫?CREATE DATABASE SampleON PRIMARY ( NAME=SampleData, c:Program Files.DataSample.mdf, SIZE=10MB, MAXSIZE=15MB, ) LOG ON ( NAME=SampleLog, c:Program Files.DataSample.ldf, SIZE=3MB, MAXSIZE=5MB, )創(chuàng)建數(shù)據(jù)庫詳細(xì)說明: 數(shù)據(jù)庫文件數(shù)據(jù)庫將存在的位置怎樣得到數(shù)據(jù)庫信息? 得到數(shù)據(jù)庫信息通過使用 DATABASEPROPERTYEX 函數(shù)利用系統(tǒng)

2、存儲過程顯示數(shù)據(jù)庫和數(shù)據(jù)庫參數(shù)信息sp_helpdbsp_helpdb database_namesp_spaceused objname Lesson: 使用文件組什么是文件組?文件組管理Northwind Database什么是文件組?Default OrderHistoryGroupE:C:D:Northwind.IdfNorthwind.mdfOrdHist2.ndfOrdHist1.ndfsys.sys.sysuserssysobjects.OrdersCustomersProductsOrdHistYear2OrdHistYear1文件組管理創(chuàng)建附加文件組指定默認(rèn)文件組ALTER

3、DATABASE NorthwindADD OrderHistoryGroupGOALTER DATABASE NorthwindMODIFY OrderHistoryGroup DEFAULTGOSizing the Primary Default Viewing InformationLesson: 管理數(shù)據(jù)庫數(shù)據(jù)和日志文件增長管理事務(wù)日志維護方針數(shù)據(jù)庫或文件壓縮數(shù)據(jù)庫刪除管理文件增長方針ALTER DATABASE Sample MODIFY FILE ( NAME = SampleLog, SIZE = 15MB)GOALTER DATABASE SampleADD FILE (NAM

4、E = SampleData2, c:Program Files. DataSample2.ndf, SIZE=15MB, MAXSIZE=20MB)GO自動文件增加擴大數(shù)據(jù)庫文件添加次要數(shù)據(jù)庫文件數(shù)據(jù)庫或文件壓縮壓縮一個完整數(shù)據(jù)庫壓縮一個數(shù)據(jù)文件到數(shù)據(jù)庫Shrinking a Database Automatically設(shè)置自動壓縮數(shù)據(jù)庫選項為真DBCC SHRINKDATABASE (Sample, 25)DBCC SHRINKFILE (Sample_Data, 10)刪除數(shù)據(jù)庫DROP DATABASE Northwind, pubs刪除數(shù)據(jù)庫的方法SQL Server Enterprise Mana