SQLServer 2008中的差异备份；能够通过SSMS恢复，但无法通过TransactSQL恢复

Question

从差异备份中恢复数据库时，我面临一个问题。以下是我执行的步骤

DROP DATABASE DBName_delta
GO
BACKUP DATABASE DBName TO DISK = 'E:\Fullbak1.bak' 
GO
RESTORE FILELISTONLY FROM DISK = 'E:\Fullbak.bak'
GO
RESTORE DATABASE DBName_delta  
    FROM  DISK='E:\Fullbak.bak' 
   WITH MOVE 'DBName_Data' TO 'E:\DBData\DBName_delta.mdf',   
   MOVE 'DBName_Image_Data' TO 'E:\DBData\DBName_delta_Image_Data.mdf',   
   MOVE 'DBName_Log' TO 'D:\DBLog\DBName_delta.ldf',
   NORECOVERY

--Made Some changes in the database
BACKUP DATABASE DBName
   TO DISK = 'E:\DiffBak1.TRN'
   WITH DIFFERENTIAL
GO

--Made Some more changes in the database    
BACKUP DATABASE DBName
   TO DISK = 'E:\DiffBak2.TRN'
   WITH DIFFERENTIAL
GO

RESTORE FILELISTONLY FROM DISK = 'E:\DiffBak1.TRN'
GO

RESTORE LOG DBName_delta FROM DISK='E:\DiffBak1.TRN' WITH NORECOVERY
GO

Msg 4305，级别16，状态1，第2行此备份集中的日志从LSN 8112500000059600297开始，该日志太新，无法应用于数据库。可以还原包含LSN 8112100000011620001的早期日志备份。

Msg 3013，16级，状态1，第2行恢复日志异常终止。

RESTORE FILELISTONLY FROM DISK = 'E:\DiffBak2.TRN'
GO
RESTORE LOG DBName_delta FROM DISK='E:\DiffBak2.TRN' WITH STANDBY = 'c:\undo.ldf'
GO

但是当我试图恢复相同的E:\DiffBak1时。通过SSMS的TRN通过使用WITH NORECOVERY选项，它还原了数据库，我再次能够使用Transact-SQL执行相同文件的还原。我错过什么了吗？这与恢复数据库有关吗？我确信我们没有遗漏任何中间的日志。任何帮助都将不胜感激。

Answer 1

我能够解决这个问题。正如我所提到的，我能够通过SSMS向导恢复差异数据库，我从向导中获取脚本并找出查询中的差异。

我正在使用下面的代码

RESTORE LOG DBName_delta FROM DISK='E:\DiffBak1.TRN' WITH NORECOVERY
GO

我已将代码更改为

RESTORE DATABASE [DBrel02t_delta] FROM  DISK = N'E:\DiffBak1.TRN' WITH  FILE = 1,  NORECOVERY,  NOUNLOAD,  STATS = 10
GO

这解决了问题。使用以下查询查找备份的lsn详细信息。

RESTORE HEADERONLY FROM DISK  = N’<backup file>’;