34,594
社区成员
发帖
与我相关
我的任务
分享
CREATE DATABASE test
ON (FILENAME = 'd:\test.mdf'),
(FILENAME = 'd:\test_log.ldf')
FOR ATTACH
GO
EXEC sp_attach_db @dbname = N'pubs',
@filename1 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs.mdf',
@filename2 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs_log.ldf'