一、创建数据库
Create DataBase DB_Test
on primary
(name='DB_Test_data',filename='E:/DB_Test.mdf',size=3,maxsize=unlimited,filegrowth=10%)
log on
(name='DB_Test_log',filename='E:/DB_Test.ldf',size=3,maxsize=10,filegrowth=10%)
二、删除数据库
Drop Database DB_Test
三、修改数据库
Alter database DB_Test
四、查看数据信息
sp_helpdb
五、压缩数据库
六、备份、恢复、附加数据库
user master
sp_addumpdevice 'disk','bb','E:/DataBase/DB_Test.dat'
backup database DB_Test to bb with init
restore database DB_Test from bb
sp_addumpdevice 'disk','bblog','E:/DataBase/DB_Testlog.dat'
backup log DB_Test to bblog
restore log DB_Test from bblog
例:
数据库名: dbweb
主要文件:c:/test/dbweb.mdf
日志文件:c:/test/dbweb_log.mdf
1、分离: sp_detach_db dbweb,true
2、附加:sp_attach_db 'dbweb','c:/test/dbweb.mdf','c:/test/dbweb_log.ldf'