使用日志恢复数据库

IF DB_ID('PRG') IS NOT NULL

DROP DATABASE PRG;

GO 

CREATE DATABASE PRG;

GO 

CREATE TABLE PRG.dbo.T(ID INT PRIMARY KEY IDENTITY(1,1));

GO 

BACKUP DATABASE PRG TO DISK='d:/1.bak' WITH FORMAT;

GO 

INSERT INTO PRG.dbo.T DEFAULT VALUES;

GO 

BACKUP LOG PRG TO DISK='d:/2.bak' WITH FORMAT;

GO 

INSERT INTO PRG.dbo.T DEFAULT VALUES;

GO 

BACKUP LOG PRG TO DISK='d:/3.bak' WITH FORMAT;

GO 

RESTORE DATABASE PRG FROM DISK='d:/1.bak' WITH RECOVERY,REPLACE;

GO 

SELECT * FROM PRG.dbo.T

GO 

RESTORE DATABASE PRG FROM DISK='d:/1.bak' WITH NORECOVERY,REPLACE;

GO 

RESTORE LOG PRG FROM DISK='d:/2.bak' WITH RECOVERY;

GO 

SELECT * FROM PRG.dbo.T

GO 

RESTORE DATABASE PRG FROM DISK='d:/1.bak' WITH NORECOVERY,REPLACE;

GO 

RESTORE LOG PRG FROM DISK='d:/2.bak' WITH NORECOVERY;

GO 

RESTORE LOG PRG FROM DISK='d:/3.bak' WITH RECOVERY;

GO 

SELECT * FROM PRG.dbo.T

GO

DROP DATABASE PRG;