sql命令附加数据库

use master;
go
create database DTcmsdb2 
on (filename='D:\work\0103\DTcmsMSSQL\DB\DTcmsdb2.mdf'),
(filename='D:\work\0103\DTcmsMSSQL\DB\DTcmsdb2_log.ldf')
for attach;
go

转子:http://msdn.microsoft.com/zh-cn/library/ms189625.aspx

原文地址:https://www.cnblogs.com/hongjiumu/p/2843377.html