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

字號(hào)： 小 中 大


    1: 無(wú)需新建數(shù)據(jù)庫(kù),直接運(yùn)行
    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: 刷新下就會(huì)出來(lái)