restore bak 文件

 

在sql server中可以设定备份任务

备份出 .bak文件

restore 到一个新的database系统中

 

步骤：

 

1.create database newname

 

2.restore file

Restore FILELISTONLY FROM DISK='d:/Business_Data.bak'

 

 

3.restore database

RESTORE DATABASE Business_Data_TSQL
FROM DISK='d:/Business_Data.bak'
WITH
MOVE 'Business_Data' TO 'D:/TSQL/Business_Data.mdf',
MOVE 'Business_Data_log' TO 'D:/TSQL/Business_Data_log.ldf'