1、说明：创建数据库CREATE DATABASE database-name 2、说明：删除数据库drop database dbname3、说明：备份sql server--- 创建 备份数据的 deviceUSE masterEXEC sp_addumpdevice disk , testBack , c:\mssql7backup\MyNwind_1.dat --- 开始 备份BACKUP DATABASE pubs TO testBack 4、说明：创建新表create table tabname(col1 type1 [not null] [primary key],col2 type2 [not null],..)-1, Descr iption: Create a database CREATE DATABASE database-name 2, Descr iption: Removes database drop database dbname3, Descr iption: backup sql server--- Create a backup of data deviceUSE masterEXEC sp_addumpdevice ' disk' , ' testBack' , ' c: \ mssql7backup \ MyNwind_1.dat ' --- start the backup BACKUP DATABASE pubs TO testBack 4, Descr iption: Create new table create table tabname (col1 type1 [not null] [primary key], col2 type2 [not null ],..)