SQL Server页级别的数据恢复

--1.最近的完整备份
BACKUP DATABASE DBName TO DISK = N'C:\Test.bak'

--2.发现错误页(可以人为破坏)
SELECT * FROM msdb.dbo.suspect_pages

--3.立即备份日志1
BACKUP LOG DBName TO
DISK = 'C:\Test_LOG1.bak'
WITH INIT

--3.用完整备份,还原数据损坏的页
USE Master
RESTORE DATABASE DBName
PAGE = '1:832'
FROM DISK = 'C:\Test.bak'
WITH NORECOVERY

--4.备份日志2
BACKUP LOG DBName TO
DISK = 'C:\Test_LOG2.bak'
WITH INIT

--5.还原日志1
RESTORE LOG DBName FROM
DISK = 'C:\Test_LOG1.bak'
WITH NORECOVERY

--6.还原日志2
RESTORE LOG DBName FROM
DISK = 'C:\Test_LOG2.bak'
WITH NORECOVERY

--7.还原数据库状态,大工告成
RESTORE DATABASE DBName WITH RECOVERY