MIS的野生動物園

使用文字介面一次建立多個資料庫檔案

USE master;

CREATE DATABASE demoscript                                           ------>資料庫名稱
ON (
NAME = demoscript_data,                                                 ------->檔案名稱
FILENAME = ‘C:\SQLData\Data\demoscript_data.mdf’,      ------->檔案路徑
SIZE = 10MB,
MAXSIZE = UNLIMITED,
FILEGROWTH = 5MB
)
,(
NAME = demoscript_data2,
FILENAME = ‘C:\SQLData\Data\demoscript_data2.ndf’,
SIZE = 10MB,
MAXSIZE = UNLIMITED,
FILEGROWTH = 5MB
)
LOG ON (
NAME = demoscript_log,
FILENAME = ‘C:\SQLData\Log\demoscript_log.mdf’,
SIZE = 5MB,
MAXSIZE = UNLIMITED,
FILEGROWTH = 2MB
);
GO