健忘症補救株式會社

--有 mdf 和 ldf 檔
EXEC sp_attach_db 'xxxxx', 'D:\[MDF FILE PATH]\xxxxx.mdf', 'D:\[LDF FILE PATH]\xxxxx_Log.ldf'

--只有 mdf 檔
CREATE DATABASE xxxxx ON (FILENAME = 'D:\[MDF FILE PATH]\xxxxx.mdf') FOR ATTACH

--若是出現下列錯誤訊息:

Unable to open the physical file "D:\[MDF FILE PATH]\xxxxx.mdf". Operating system error 5: "5(存取被拒。)"

Solution: 以系統管理員身分去執行SSMS (SSMS上按滑鼠右鍵-->以系統管理員身分執行), 可能是因為Windows 7 or Vista上的UAC阻擋

or:
The database 'xxxxx' cannot be opened because it is version 661. This server supports version 655 and earlier. A downgrade path is not supported

Solution: Attach MDF檔是由較新的版本的SQL SEVER 上複製過來的,但是要Attach上去的SQL SERVER版本比較舊.(ex. SQL SERVER 2008 R2 --> SQL SERVER 2005),

               找一台相同版本的機器import data, 再拿這個MDF去目的SERVER 上做Attach的動作.