–创建数据库
create database mydb
on primary
(
name=mydbdata,
Filename=’E:\mydb_data.mdf’,
size=5mb,
maxsize=6mb,
Filegrowth=1mb
)
log on
(
name=mydblog,
filename=’E:\mydb_log.ndf’,
size=2mb,
maxsize=5mb,
filegrowth=1%
)
–删除数据库
use master
go
if exists(select * from sysdatabases where name=’mydb’)
drop database mydb
go
–添加次数据库
alter database mydb
add log file
(
name=mydalog2,
filename=’E:\mydb_log2.ndf’,
size=1mb,
maxsize=5mb,
filegrowth=1%
)
–删除次数据库
alter database mydb
remove file mydalog2
–修改数据库名字
alter database mydb
modify name=youdb
–备份数据库 –name=’mydbbackup’是备注随便写
backup database mydb to disk=’E:\mydbbackup.bak’ with format, name=’mydbbackup’
–恢复数据库
USE master
GO
restore database mydb from disk=’E:\mydbbackup.bak’
GO
