sqlserver2008通过mdf与ldf还原数据库

USE master;
 GO
 CREATE DATABASE CardioScansEerver
     ON (FILENAME = 'C:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLDATACardioScanServer.mdf'),
     (FILENAME = 'C:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLDATACardioScanServer.ldf')
     FOR ATTACH;
 GO

注意，执行命令之前需要把mdf与ldf放在命令指定路径下。