SQL新增資料夾檔

-- Workshop 20100722

CREATE DATABASE DBTest01
ON PRIMARY
( NAME = Test_C1,
FILENAME = 'C:\SQLTEST_C\main\Test_C1.MDF',
SIZE = 5, MAXSIZE = 10, FILEGROWTH = 15% ) ,
( NAME = Test_C2,
FILENAME = 'C:\SQLTEST_C\sub\Test_C2.NDF',
SIZE = 5, MAXSIZE = 10, FILEGROWTH = 15% ) ,
FILEGROUP Group_1
( NAME = Test_sub1_1,
FILENAME = 'D:\SQLTEST_D\sub1\Test_sub1_1.NDF',
SIZE = 5, MAXSIZE = 10, FILEGROWTH = 5 ) ,
( NAME = Test_sub1_2,
FILENAME = 'D:\SQLTEST_D\sub1\Test_sub1_2.NDF',
SIZE = 5, MAXSIZE = 10, FILEGROWTH = 5 ) ,
FILEGROUP Group_2
( NAME = Test_sub2_1,
FILENAME = 'D:\SQLTEST_D\sub2\Test_sub2_1.NDF',
SIZE = 5, MAXSIZE = 10, FILEGROWTH = 5 ) ,
( NAME = Test_sub2_2,
FILENAME = 'D:\SQLTEST_D\sub2\Test_sub2_2.NDF',
SIZE = 5, MAXSIZE = 10, FILEGROWTH = 5 )
GO