Restore Database from bak file

--Restore db from local bak File

restore database NewDB from disk = 'C:\backup.bak'

with move 'OldDB' to 'C:\Program Files\Microsoft SQL Server\MSSQL10.SERVER\MSSQL\DATA\NewDB.mdf'

,move 'OldDB_log' to 'C:\Program Files\Microsoft SQL Server\MSSQL10.SERVER\MSSQL\DATA\NewDB_0.ldf'




--Restore db from remote bak File

restore database NewDB from disk = '\\Server\share\backup.bak'

with move 'OldDB' to 'C:\Program Files\Microsoft SQL Server\MSSQL10.SERVER\MSSQL\DATA\NewDB.mdf'

,move 'OldDB_log' to 'C:\Program Files\Microsoft SQL Server\MSSQL10.SERVER\MSSQL\DATA\NewDB_0.ldf'

檔案來源為遠端的電腦，利用unc取得遠端bak檔，

本機的Sql Server帳戶，登入身份為administrator,

且密碼需跟遠端電腦的administrator密碼相同，才不會出現登入失敗的錯誤




--查看邏輯檔案名稱

restore filelistonly from disk='';

LogicalName不可更動




--查看mdf儲存路徑

select name,filename from master.dbo.sysdatabases where name='master' ;




--備註

此作法覆蓋或新建都不會出現怪奇的訊息