--得到需要恢复的LogicalName
restore filelistonly from disk='D:\project\up\a\db\8-13\123456.bak'
--执行命令，复制新数据库
RESTORE DATABASE newdbname
FROM DISK ='D:\project\up\a\db\8-13\123456.bak'
WITH MOVE 'dbname' TO 'D:\project\up\a\db\demotest\newdbname.mdf',
MOVE 'dbname_log' TO 'D:\project\up\a\db\demotest\newdbname_log.ldf'
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
