資料庫還原並移動位置
發表人 admin 於 2019/1/16 15:38:33
RESTORE DATABASE EFPOS
FROM DISK ='C:\EFPOS\Install\EFPOS.DAT'
with move "EFPOS_Data" to "C:\Program Files (x86)\Microsoft SQL Server\MSSQL\Data\EFPOS_Data.mdf",
move "EFPOS_log" to "C:\Program Files (x86)\Microsoft SQL Server\MSSQL\Data\EFPOS_log.ldf"
FROM DISK ='C:\EFPOS\Install\EFPOS.DAT'
with move "EFPOS_Data" to "C:\Program Files (x86)\Microsoft SQL Server\MSSQL\Data\EFPOS_Data.mdf",
move "EFPOS_log" to "C:\Program Files (x86)\Microsoft SQL Server\MSSQL\Data\EFPOS_log.ldf"
來自： http://www.tene.url.tw/newbb/viewtopic.php?forum=5&topic_id=6&post_id=6