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;