步骤如下:
1、把mdf文件和ldf文件拷贝到数据库的默认路径下,例如:D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA
2、在sqlserver里新建个查询,执行下面代码:
USE master;
GO
CREATE DATABASE bookshop
ON (FILENAME = 'D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\bookshop.mdf'),
(FILENAME = 'D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\bookshop_log.ldf')
FOR ATTACH;
GO
3、刷新数据库,怎会出现名为bookshop的数据库。