USE master
RESTORE FILELISTONLY
FROM DISK = 'C:/Inetpub/wwwroot/VBftp/test.bak' '原数据库备份的存放位置
Go
USE master
RESTORE DATABASE DB
FROM DISK = 'C:/Inetpub/wwwroot/VBftp/test.bak'
WITH MOVE 'SDMS_Data' TO 'C:/Inetpub/wwwroot/VBftp/DB_data.mdf', '新数据库的名字, SDMS_Data:点原数据库属性,就可以查看到.
MOVE 'SDMS_log' TO 'C:/Inetpub/wwwroot/VBftp/DB_log.ldf',
STATS = 10, REPLACE 'REPLACE强制转换
GO