差异备份的问题
各位高手，sql server2000中如何进行差异备份，最难的是差异备份以后，如何进行差异还原，我差异还原的时候提示错误，应该如何解决，急！！！！！
分不够再加！！！！
[解决办法]
例如：
restore database dbname from disk= 'c:\完全备份文件 ' with norecovery
restore database dbname from disk= 'c:\差异备份文件1 ' with norecovery
restore database dbname from disk= 'c:\差异备份文件2 ' with recovery
[解决办法]
RESTORE FILELISTONLY from disk= 'D:\fullbak ' --查看一下备份文件及逻辑名
go
restore database test
from disk= 'D:\fullbak ' with NoRECOVERY,
MOVE 'BTools_Data ' TO 'D:\test.mdf ',
MOVE 'BTools_Log ' TO 'D:\test_log.ldf '
go
restore database test from disk= 'D:\difbak1 ' with RECOVERY
