Server 2008 Express还原不同

Question

服务器1

备份满

USE master;  

ALTER DATABASE Parking SET RECOVERY FULL;  
GO  

-- Back up the Parking database to new media set (backup set 1).  
BACKUP DATABASE Parking  
TO DISK = 'c:\backup\parking.bak'   
WITH FORMAT;  
GO  

--Create a routine log backup (backup set 2).  
BACKUP LOG Parking TO DISK = 'c:\backup\parking.bak';  
GO 

后备差分法

BACKUP DATABASE Parking TO DISK = 'C:\backup\dif.DIF' WITH DIFFERENTIAL

服务器2

恢复

ALTER DATABASE Parking SET RESTRICTED_USER WITH ROLLBACK IMMEDIATE;

USE Parking;

ALTER DATABASE Parking SET SINGLE_USER WITH ROLLBACK IMMEDIATE;

USE tempdb;

DROP DATABASE Parking;

RESTORE DATABASE Parking 
FROM DISK = 'C:\backup\parking.bak' WITH NORECOVERY;
GO

RESTORE DATABASE Parking     
FROM DISK = 'C:\backup\dif.DIF' WITH RECOVERY;  
GO  

控制台中的输出：

Processed 122736 pages for database 'Parking', file 'Parking' on file 1.
Processed 381464 pages for database 'Parking', file 'FG_RECORD' on file 1.
Processed 14 pages for database 'Parking', file 'Parking_log' on file 1.
Processed 0 pages for database 'Parking', file 'Parking_media' on file 1.
RESTORE DATABASE successfully processed 504214 pages in 217.089 seconds (18.145 MB/sec).

1>   
2> Processed 320 pages for database 'Parking', file 'Parking' on file 1.
Processed 392 pages for database 'Parking', file 'FG_RECORD' on file 1.
Processed 7 pages for database 'Parking', file 'Parking_log' on file 1.
Processed 0 pages for database 'Parking', file 'Parking_media' on file 1.
RESTORE DATABASE successfully processed 719 pages in 11.613 seconds (0.483 MB/sec).

完整的数据存在于数据库中，而DIFF数据不添加在数据库中。

Answer 1

diff备份包含自/在上一次/最近一次完全备份之后数据库中发生的所有/任何更改(不包括使用COPY_ONLY进行的完全备份)。

您可以通过在完全备份之后和在diff备份之前进行更改来测试这一点：

--full backup
BACKUP DATABASE Parking  
TO DISK = 'c:\backup\parking.bak'   
WITH FORMAT;  
GO  

--a change after the full backup
create table Parking..footable(foocolumn bit)
go


--Backup DIFF : this will contain footable
BACKUP DATABASE Parking TO DISK = 'C:\backup\dif.DIF' WITH DIFFERENTIAL
go