SQL Server恢复mdf、ldf为数据库的方法

USE master;
GO
CREATE DATABASE mydb
    ON (FILENAME = 'D:\MSSQL_DATA\DATA\mydb.mdf'),
    (FILENAME = 'D:\MSSQL_DATA\DATA\mydb.ldf')
    FOR ATTACH;
GO