sqlserver 恢复步骤
1. 先恢复数据文件
GO
RESTORE DATABASE BIMQ_2017
FROM DISK='D:\BACKUP\FULL\BIMQ_2017\BIMQ_2017_BACKUP_2018_10_07_010002_4417366.BAK'
WITH NORECOVERY,
MOVE 'BIMQ_2017' TO 'D:\DATA\BIMQ_2017.MDF',
MOVE 'BIMQ_2017_LOG' TO 'D:\DATA\BIMQ_2017_LOG.LDF'
GO
2.恢复trn事物日志
GO
RESTORE LOG BIMQ_2017
FROM DISK='D:\BACKUP\LOG\BIMQ_2017\BIMQ_2017_BACKUP_2018_10_07_020005_2542789.TRN'
WITH NORECOVERY
GO
GO
RESTORE LOG BIMQ_2017
FROM DISK='D:\BACKUP\LOG\BIMQ_2017\BIMQ_2017_BACKUP_2018_10_07_030004_2103779.TRN'
WITH NORECOVERY
GO
GO
RESTORE LOG BIMQ_2017
FROM DISK='D:\BACKUP\LOG\BIMQ_2017\BIMQ_2017_BACKUP_2018_10_07_040004_8985132.TRN'
WITH NORECOVERY
GO
RESTORE LOG BIMQ_2017
FROM DISK='D:\BACKUP\LOG\BIMQ_2017\BIMQ_2017_BACKUP_2018_10_07_050004_1520225.TRN'
WITH RECOVERY
GO
-- WITH NORECOVERY :不对数据库做任何操作,不回滚未提交的事物,可以继续恢复后面的日志
-- WITH RECOVERY : 回滚未提交的事物,使数据库处于使用状态,无法继续恢复后面的日志
--获得数据库备份文件的信息
restore filelistonly from disk='D:\backup\full\TMS\TMS_backup_2018_10_16_145219_0088262.bak'
在恢复的时候,逻辑文件名不可以修改,指定的物理文件存放的位置必须存在。