{SQL} 本機還原資料庫執行步驟

紅框處新增查詢頁面，輸入下列sql
路徑轉為自已bak相關路徑

restore DATABASE KTMS
from disk='D:\KTMS.bak'  
with
move 'KTMS' to 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\KTMS.mdf',
move 'KTMS_Log' to 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\KTMS_log.ldf'
,NoRecovery
,Replace
go



重覆一次還回資料庫動作，即可完成

參考資訊：http://blog.yam.com/iamshiao/article/18601917