创建数据库

创建数据库：

1 CREATE DATABASE zmr
2     on primary
3     (
4         name = 'StudentDB',
5         filename = 'T:\DB\StudentDB.mdf',
6         size = 3mb,
7         maxsize = unlimited, 
8         filegrowth = 1mb --为0则不允许自动增加空间
9     )

 

 

 

 

例1：创建一个全部使用默认值的数据库

主要数据文件大小为model数据库主要数据文件的大小。

事务日志大小：512KB或主要数据文件大小的25%。

如没有指定maxsize，可增大到填满所有可用的磁盘空间为止。

create database mytest

 

 

例2：创建指定一个数据文件和一个日志文件的数据库

 1 create database RShDB
 2 on primary
 3 (
 4     name = 'RShDB_Data',
 5     filename = 'T:\DB\RShDB_Data.mdf',
 6     size = 10mb,
 7     maxsize = 30mb,
 8     filegrowth = 5mb
 9 )
10 log on 
11 (
12     name = 'RShDB_log',
13     filename = 'T:\DB\RShDB_log.ldf',
14     size = 3mb,
15     maxsize = 12mb,
16     filegrowth = 2mb
17 )

 

 

 例3：创建指定多个数据文件和多个事务日志的数据库

 1 create database Students
 2 on primary
 3 (
 4     name = 'student_data1',
 5     filename = 'T:\DB\student_data1.mdf',
 6     size = 5mb,
 7     maxsize = unlimited,
 8     filegrowth = 1mb
 9 ),
10 (
11     name = 'student_data2',
12     filename = 'T:\DB\student_data2.ndf',
13     size = 8mb,
14     maxsize = 20mb,
15     filegrowth = 2mb
16 )
17 LOG ON
18 (
19     name = 'student_log1',
20     filename = 'T:\DB\student_log1.ldf',
21     size = 2MB,
22     maxsize = 6mb,
23     filegrowth = 10%
24 ),
25 (
26     name = 'student_log2',
27     filename = 'T:\DB\student_log2.ldf',
28     size = 3mb,
29     maxsize = 8mb,
30     filegrowth = 1mb
31 )

 

 

例4：创建一个数据库，除了有主文件组primary，还有group1，group2

 1 --创建具有文件组的数据库，除了主文件组primary，还包括group1和group2
 2 create database Sales
 3 on primary
 4 (
 5     name = 'Spri1_dat',
 6     filename = 'T:\DB\Spri1.mdf',
 7     size = 10mb,
 8     maxsize = 50mb,
 9     filegrowth = 15%
10 ),
11 (
12     name = 'Spri2_dat',
13     filename = 'T:\DB\Spri2.ndf',
14     size = 10mb,
15     maxsize = 50mb,
16     filegrowth = 15%    
17 ),
18 filegroup group1
19 (
20     name = 'Sgrp1fi1_dat',
21     filename = 'T:\DB\Sgrp1fi1_dat.ndf',
22     size = 10mb,
23     maxsize = 50mb,
24     filegrowth = 5mb    
25 ),
26 (
27     name = 'Sgrp1fi2_dat',
28     filename = 'T:\DB\Sgrp1fi2_dat.ndf',
29     size = 10mb,
30     maxsize = 50mb,
31     filegrowth = 5mb    
32 ),
33 filegroup group2
34 (
35     name = 'Sgrp2fi1_dat',
36     filename = 'T:\DB\Sgrp2fi1_dat.ndf',
37     size = 10mb,
38     maxsize = 50mb,
39     filegrowth = 5mb    
40 ),
41 (
42     name = 'Sgrp2fi2_dat',
43     filename = 'T:\DB\Sgrp2fi2_dat.ndf',
44     size = 10mb,
45     maxsize = 50mb,
46     filegrowth = 5mb    
47 )
48 log on
49 (
50     name = 'sales_log',
51     filename = 'T:\DB\sales_log.ldf',
52     size = 5mb,
53     maxsize = 25mb,
54     filegrowth = 5mb
55 )

 

posted @ 2020-06-19 18:37  幻想Elapse  阅读(312)  评论(0)  编辑  收藏  举报