--参考 备份 BACKUP DATABASE text to disk='c:\11.bak' with init还原 RESTORE DATABASE CDJTLZGIS FROM DISK = 'c:\33.bak' WITH MOVE 'CDJTLZGIS_Data' TO 'c:\CDJTLZGIS_Data', MOVE 'CDJTLZGIS_Log' TO 'c:\CDJTLZGIS_Log' RESTORE DATABASE TestDB FROM DISK = 'c:\Northwind.bak' WITH MOVE 'Northwind' TO 'c:\testdb.mdf', MOVE 'Northwind_log' TO 'c:\testdb.ldf'
restore database nams from disk='c:\nams.bak'with recovery,password='DBCs@%1+ZhLx', move 'nams_data' to 'd:\program files\zhlx\namsdbengine\data\1\nams.mdf', move 'nams_log' to 'd:\program files\zhlx\namsdbengine\data\1\nams_log.ldf', replace
RESTORE DATABASE 还原后数据库的名称 FROM DISK = '备份文件的路径\备份数据库名称.bak' WITH MOVE '备份数据库名称(不带扩展名)' TO '还原后的路径\还原后数据库的名称.bak', MOVE '备份数据库名称(不带扩展名)_log' TO '还原后的路径\还原后数据库的名称_log.ldf'
备份
BACKUP DATABASE text
to disk='c:\11.bak' with init还原
RESTORE DATABASE CDJTLZGIS
FROM DISK = 'c:\33.bak'
WITH MOVE 'CDJTLZGIS_Data' TO 'c:\CDJTLZGIS_Data',
MOVE 'CDJTLZGIS_Log' TO 'c:\CDJTLZGIS_Log'
RESTORE DATABASE TestDB
FROM DISK = 'c:\Northwind.bak'
WITH MOVE 'Northwind' TO 'c:\testdb.mdf',
MOVE 'Northwind_log' TO 'c:\testdb.ldf'
restore database nams from disk='c:\nams.bak'with recovery,password='DBCs@%1+ZhLx',
move 'nams_data' to 'd:\program files\zhlx\namsdbengine\data\1\nams.mdf',
move 'nams_log' to 'd:\program files\zhlx\namsdbengine\data\1\nams_log.ldf',
replace
FROM DISK = '备份文件的路径\备份数据库名称.bak'
WITH MOVE '备份数据库名称(不带扩展名)' TO '还原后的路径\还原后数据库的名称.bak',
MOVE '备份数据库名称(不带扩展名)_log' TO '还原后的路径\还原后数据库的名称_log.ldf'