實(shí)驗(yàn)一sqlserver服務(wù)器管理及創(chuàng)建數(shù)據(jù)庫(kù)(參考版)
2025-04-10 23:07本頁(yè)面
【正文】 進(jìn)一步了解了數(shù)據(jù)庫(kù)的認(rèn)識(shí)。實(shí)驗(yàn)總結(jié)（結(jié)論或問(wèn)題分析）：本次試驗(yàn)SQL數(shù)據(jù)庫(kù)文件進(jìn)行了創(chuàng)建，收縮，創(chuàng)建快照等操作。12．（選做）寫出創(chuàng)建快照的語(yǔ)句，給Sales數(shù)據(jù)庫(kù)創(chuàng)建快照。, SIZE = 5MB, MAXSIZE = 25MB, FILEGROWTH = 5MB )10．上述Sales數(shù)據(jù)庫(kù)創(chuàng)建成功后，在SSMS中收縮Sales數(shù)據(jù)庫(kù)，記錄收縮后數(shù)據(jù)庫(kù)的大小，要求收縮后數(shù)據(jù)庫(kù)至少減小10M。, SIZE = 10, MAXSIZE = 50, FILEGROWTH = 5 )LOG ON( NAME = Sales_log, FILENAME = 39。, SIZE = 10, MAXSIZE = 50, FILEGROWTH = 5 ),FILEGROUP SalesGroup2( NAME = Sales_ndata4, FILENAME = 39。, SIZE = 10, MAXSIZE = 50,
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1