sql server数据库还原备份 sql语句

RESTORE FILELISTONLY FROM DISK=‘D:\web\dbbak\JieXi\JieXi_backup_07150600.bak’

RESTORE DATABASE JieXi

FROM DISK=‘D:\web\dbbak\JieXi\JieXi_backup_07150600.bak’

WITH MOVE ‘czhs’ to ‘D:\web\db\JieXi.mdf’,

MOVE ‘czhs_log’ to ‘D:\web\db\JieXi_1.ldf’

如果觉得《sql server数据库还原备份 sql语句》对你有帮助，请点赞、收藏，并留下你的观点哦！