數(shù)據(jù)庫原理及應(yīng)用---第4章sqlserver2005數(shù)據(jù)庫的創(chuàng)建和管理-文庫吧資料
2024-10-25 19:41本頁面
【正文】 ata path DECLARE data_path nvarchar(256)。 數(shù)據(jù)庫原理及應(yīng)用 TSQL語句創(chuàng)建數(shù)據(jù)庫 USE master。但是，由于文件的位置自創(chuàng)建后沒有發(fā)生更改，所以只需在 FOR ATTACH 子句中指定主文件。, SIZE = 100MB, MAXSIZE = 200, FILEGROWTH = 20) 數(shù)據(jù)庫原理及應(yīng)用 TSQL語句創(chuàng)建數(shù)據(jù)庫 ? 例： 分離在示例 4中創(chuàng)建的數(shù)據(jù)庫 Archive，然后使用 FOR ATTACH 子句附加該數(shù)據(jù)庫。39。39。, SIZE = 100MB, MAXSIZE = 200, FILEGROWTH = 20), (NAME = Archlog2, FILENAME = 39。39。39。, SIZE = 100MB, MAXSIZE = 200, FILEGROWTH = 20) LOG ON (NAME = Archlog1, FILENAME = 39。39。39。, SIZE = 100MB, MAXSIZE = 200, FILEGROWTH = 20), ( NAME = Arch3, FILENAME = 39。39。39。, SIZE = 100MB, MAXSIZE = 200, FILEGROWTH = 20), ( NAME = Arch2, FILENAME = 39。39。39。 數(shù)據(jù)庫原理及應(yīng)用 TSQL語句創(chuàng)建數(shù)據(jù)庫 CREATE DATABASE Archive ON PRIMARY (NAME = Arch1, FILENAME = 39。事務(wù)日志文件在 LOG ON 關(guān)鍵字后指定。, SIZE=1, MAXSIZE=2, FILEGROWTH=10% ) 數(shù)據(jù)庫原理及應(yīng)用 TSQL語句創(chuàng)建數(shù)據(jù)庫 ? 例： 創(chuàng)建數(shù)據(jù)庫 Archive，該數(shù)據(jù)庫具有三個 100MB 數(shù)據(jù)文件和兩個 100MB 事務(wù)日志文件。, SIZE=3, MAXSIZE=10, FILEGROWTH=10% ) LOG ON (NAME=Library_log, FILENAME=39。 數(shù)據(jù)庫原理及應(yīng)用 TSQL語句創(chuàng)建數(shù)據(jù)庫 CREATE DATABASE Library On (NAME= Library, FILENAKME=39。F:\練習(xí)日志 \39。test_log39。E:\練習(xí)數(shù)據(jù) \39。test39。 } [ , SIZE = size [ KB | MB | GB | TB ] ] [ , MAXSIZE = { max_size [ KB | MB | GB | TB ] | UNLIMITED } ] [ , FILEGROWTH = growth_increment [ KB | MB | GB | TB | % ] ]) [ ,...n ]} 數(shù)據(jù)庫原理及應(yīng)用 TSQL語句創(chuàng)建數(shù)據(jù)庫 filegroup ::= {FILEGROUP filegroup_name [ CONTAINS FILESTREAM ]
教學(xué)課件相關(guān)推薦
鄂ICP備17016276號-1