数据库备份后还原到标识事务

--还原到标识事务

CREATE DATABASE PRG 

GO 

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

GO 

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

GO 

BEGIN TRAN Tran1 WITH MARK

INSERT INTO PRG.dbo.T SELECT 1

COMMIT TRAN Tran1 

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

GO 

DROP DATABASE PRG;

GO 

RESTORE DATABASE PRG FROM DISK='D:/1.bak' WITH NORECOVERY;

GO 

RESTORE LOG PRG FROM DISK='D:/2.bak' WITH STOPBEFOREMARK='Tran1';

GO 

SELECT COUNT(*) FROM PRG.dbo.T 

DROP DATABASE PRG;

GO 

RESTORE DATABASE PRG FROM DISK='D:/1.bak' WITH NORECOVERY;

GO 

RESTORE LOG PRG FROM DISK='D:/2.bak' WITH STOPATMARK='Tran1';

GO 

SELECT COUNT(*) FROM PRG.dbo.T

DROP DATABASE PRG