2015-02-28 21:23:14
use master
-- 备份
backup
database
[数据库名]
to
disk=
'D:\database.bak'
with
format,init
-- 还原
restore
database
TEST
from
disk=
'D:\database.bak'
with
replace
,
move
'[mdf文件]'
to
N
'[路径]\[mdf文件名]'
,
move
'[ldf文件]'
to
N
'[路径]\[ldf文件名]'