CREATE DATABASE student
ON
(
NAME=student,
FILENAME = 'D:\SqlServer2008学习\test\student.mdf',
SIZE = 5MB,
MAXSIZE = 20MB,
FILEGROWTH = 5%
)
LOG ON
(
NAME = student_LOG,
FILENAME='D:\SqlServer2008学习\test\student_LOG.ldf',
SIZE = 2MB,
MAXSIZE = 10MB,
FILEGROWTH = 1MB
)
ON
(
NAME=student,
FILENAME = 'D:\SqlServer2008学习\test\student.mdf',
SIZE = 5MB,
MAXSIZE = 20MB,
FILEGROWTH = 5%
)
LOG ON
(
NAME = student_LOG,
FILENAME='D:\SqlServer2008学习\test\student_LOG.ldf',
SIZE = 2MB,
MAXSIZE = 10MB,
FILEGROWTH = 1MB
)