從mdf|ldf文件恢復(fù)sqlserver數(shù)據(jù)庫

    1: 無需新建數(shù)據(jù)庫,直接運行
    USE master;
    GO
    CREATE DATABASE test
    ON (FILENAME = 'D:Program FilesMicrosoft SQL ServerMSSQL10.MSSQLSERVERMSSQLDATAtest.mdf'),
    (FILENAME = 'D:Program FilesMicrosoft SQL ServerMSSQL10.MSSQLSERVERMSSQLDATAtest_log.ldf')
    FOR ATTACH;
    GO
    如需其它文件,復(fù)制到相應(yīng)位置即可
    2: 刷新下就會出來