22,209
社区成员
发帖
与我相关
我的任务
分享
1/ 获得原库逻辑名
RESTORE FILELISTONLY FROM disk= 'D:\lgs_backup_201012270300.bak'
2/ 新建空库
USE [master]
GO
--在D盘新建lgs文件夹
CREATE DATABASE [lgs_backup] ON PRIMARY
( NAME = N'lgs_backup' --修改为第1步查询的逻辑文件名
, FILENAME = N'D:\lgs\lgs_backup.mdf'
) LOG ON
( NAME = N'lgs_backup_log' --修改为第1步查询的逻辑日志名
, FILENAME = N'D:\lgs\lgs_backup_log.ldf')
GO
3/ 还原数据库
RESTORE DATABASE [lgs_backup] FROM DISK = N'D:\lgs_backup_201012270300.bak'
WITH FILE = 1, REPLACE
GO
restore database lgs from disk='[路径]\[BAK文件]' with recovery,
move 'lgs' to '[路径]\lgs.mdf',
move 'lgs_log' to '[路径]\lgs_log.ldf'
restore database lgs from disk='[路径]\[BAK文件]' with norecovery,
move 'lgs' to '[路径]\lgs.mdf',
move 'lgs_log' to '[路径]\lgs_log.ldf'
restore database lgs from disk='[路径]\[BAK文件]' with replace,
move Lgs to disk='新的路径\数据文件名',
move lgs_log to disk='新的路径\日志文件名'
restore database [数据库名称] from disk='[路径]\[BAK文件]'
restore headeronly from disk='[路径]\[BAK文件]'
-->结果里有个DatabaseName(数据库名称)的字段.