--创建数据库
create database TestDB
--行数据
on primary(
   --数据文件参数设置
   name='TestDB',
   size=5MB,
   filegrowth=1MB,
   maxsize=unlimited,
   filename='C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\DATA\TestDB.mdf'
),
filegroup group1(
   --次数据文件参数设置
   name='TestDB1',
   size=5MB,
   filegrowth=1MB,
   maxsize=unlimited,
   filename='C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\DATA\TestDB.ndf'
)
log on(
   --日志文件参数设置
   name='TestDB_log',
   size=2MB,
   filegrowth=10%,
   maxsize=unlimited,
   filename='C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\DATA\TestDB.ldf'
)


--备份数据库
backup database TestDB
to disk='C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\DATA\TestDB'

--删除数据库
use master
drop database TestDB

--使用数据库
use TestDB

--还原数据库
use master
restore database TestDB
from disk='C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\DATA\TestDB'