1.创建数据库

create database test2
on primary
(name='test2_data',
filename='E:\学习笔记\sqlserver\主文件和日志文件存放\test2.mdf',
size=5mb,
maxsize=20mb,
filegrowth=5mb)
log on 
(name='test2_data1',
filename='E:\学习笔记\sqlserver\主文件和日志文件存放\test2.ldf',
size=5mb,
maxsize=20mb,
filegrowth=5mb)