ms sqlserver 数据库附加与分离脚本

1.数据库分离：

use master--分离数据库if exists(select   1   from   sys.databases   where   name=N'testDB') beginALTER DATABASE testDB  SET OFFLINE EXEC sp_detach_db  N'testDB' end

2.数据库附加：

use master--分离数据库if exists(select   1   from   sys.databases   where   name=N'testDB') beginALTER DATABASE testDB  SET OFFLINE EXEC sp_detach_db  N'testDB' enddeclare @dbpath nvarchar(150);declare @dbnamepath nvarchar(200);declare @dblogpath nvarchar(200);declare @mydbname nvarchar(50);set @dbpath=N'D:\workspace\db\';--附加数据库set @mydbname=N'testDB';set @dbnamepath =@dbpath+N'testDB.mdf';set @dblogpath =@dbpath+N'testDB_log.LDF';EXEC sp_attach_db @dbname = @mydbname, @filename1 = @dbnamepath, @filename2 = @dblogpath