1 --获取所有数据库的名称 2 select [name] from master.dbo.sysdatabases where [name]='master' 3  4 --判断数据库是否存在 5 if exists(select [name] from master.dbo.sysdatabases where [name]='master') 6      7     begin 8      select 1; 9     end10  else11     begin12     select 0;13     end14 15 --分离数据库-----要先获取所有的数据库16 if exists(select [name] from master.dbo.sysdatabases where [name]='zuobiao')17     18     begin19     exec sp_detach_db 'zuobiao'20      select 1;21     end22  else23     begin24     select 0;25     end26 27 --附加数据库-------要判断要附加的数据库是否存在28 if exists(select [name] from master.dbo.sysdatabases where [name]='zuobiao')29     30     begin31      select 0;32     end33  else34     begin35     exec sp_attach_db @dbname='zuobiao'36                       ,@filename1='D:\Program Files\SQL Server\MSSQL.1\MSSQL\Data\zuobiao.mdf'37                       ,@filename2='D:\Program Files\SQL Server\MSSQL.1\MSSQL\Data\zuobiao_log.LDF'38     select 1;39     end40 41 ---备份数据库42 use master 43 go44 backup database demo to disk='d:\database\demo.bak'45 46 --还原数据库47 use master 48 go49 restore database demo 50 from disk='d:\database\demo.bak' 51 with replace