一、创建数据库

create database mrkj on primary (  name=mrkj_data,  filename='D:\data2\mrkj.mdf',  size=5MB,  MAXSIZE=UNLIMITED,  FILEGROWTH=10% ) LOG ON (  NAME=MRKJ_LOG,  FILENAME='D:\data2\mrkj.ldf',  size=3MB,  MAXSIZE=50MB,  FILEGROWTH=2MB )

二、创建有两个次要数据库文件的数据库，

create database mingri on primary (   name=mingri1,   filename='d:\data2\mingri1.mdf',   size=100mb,   maxsize=unlimited,   filegrowth=10mb ), (  name=mingri2,  filename='d:\data2\mingri2.ndf',  size=80mb,  maxsize=200mb,  filegrowth=5mb ), (   name=mingri3,   filename='d:\data2\mingri3.ndf',   size=20mb,   maxsize=200mb,   filegrowth=10% ) log on (  name=mingrilog1,  filename='d:\data2\mingri1.ldf',  size=30mb,  maxsize=50mb,  filegrowth=1mb ), (  name=mingrilog2,  filename='d:\data\mingrilog2.ldf',  size=30mb,  maxsize=50mb,  filegrowth=1mb  )

三、给现有数据库添加次要数据库

alter database mrkj add file (   name=mrkj,   filename='d:\data2\mrkj.ndf',   size=10mb,   maxsize=100mb,   filegrowth=2mb )

四删除

alter database mingri remove file mingri3

此处的数据库名称不能写成mingri3.ndf