用SQL命令创建数据库

USE master;
GO
CREATE DATABASE db_MyDemo
ON
(
  NAME = MyDemo_data, /*指定文件的逻辑名称*/
  FILENAME = 'D:\mydemo_dat.mdf',/*物理文件名称*/
  SIZE = 10,/*指定文件大小，单位MB*/
  MAXSIZE = 50,/*文件最大值，单位MB*/
  FILEGROWTH = 5  /*自动增量*/
)
LOG ON
(
   Name = MyDemo_log,
   FILENAME = 'D:\mydemo_log.ldf',
   SIZE = 5MB,
   MAXSIZE = 25MB,
   FILEGROWTH = 5MB
)
GO

转载于:https://www.cnblogs.com/yongtaiyu/archive/2012/02/28/2371700.html