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

1.数据库分离：

use master
--分离数据库
if exists(select   1   from   sys.databases   where   name=N'testDB') 
begin
ALTER 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') 
begin
ALTER DATABASE testDB  SET OFFLINE 
EXEC sp_detach_db  N'testDB' 
end

declare @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