创建基于文件组的数据库SQL救命语句

最新推荐文章于 2024-09-30 09:09:52 发布

weixin_34138377

最新推荐文章于 2024-09-30 09:09:52 发布

阅读量144

点赞数 2

文章标签：数据库

 1 CREATE DATABASE Sales
 2 ON
 3 PRIMARY
 4 (NAME = SPri1_dat,
 5     FILENAME = 'D:\SQLDB\SPri1dat.mdf',
 6     SIZE = 10,
 7     MAXSIZE = 50,
 8     FILEGROWTH = 15%),
 9 (NAME = SPri2_dat,
10     FILENAME = 'D:\SQLDB\SPri2dt.ndf',
11     SIZE = 10,
12     MAXSIZE = 50,
13     FILEGROWTH = 15%),
14 FILEGROUP SalesGroup1
15 (NAME = SGrp1Fi1_dat,
16     FILENAME = 'D:\SQLDB\SG1Fi1dt.ndf',
17     SIZE = 10,
18     MAXSIZE = 50,
19     FILEGROWTH = 5),
20 (NAME = SGrp1Fi2_dat,
21     FILENAME = 'D:\SQLDB\SG1Fi2dt.ndf',
22     SIZE = 10,
23     MAXSIZE = 50,
24     FILEGROWTH = 5),
25 FILEGROUP SalesGroup2
26 (NAME = SG2Fi1_dat,
27     FILENAME = 'D:\SQLDB\SG2Fi1dt.ndf',
28     SIZE = 10,
29     MAXSIZE = 50,
30     FILEGROWTH = 5),
31 (NAME = SG2Fi2_dat,
32     FILENAME = 'D:\SQLDB\SG2Fi2dt.ndf',
33     SIZE = 10,
34     MAXSIZE = 50,
35     FILEGROWTH = 5)
36 LOG ON
37 (NAME = Sales_log,
38     FILENAME = 'D:\SQLDB\salelog.ldf',
39     SIZE = 5MB,
40     MAXSIZE = 25MB,
41     FILEGROWTH = 5MB );