USE master;

ALTER DATABASE sampledb SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
GO
 
BACKUP LOG sampledb TO DISK=N'C:\backups\sampledb\taillog.bkp' WITH NORECOVERY;
GO

RESTORE DATABASE [sampledb] FROM  DISK = N'C:\backups\sampledb\pitr_full.bkp' WITH NORECOVERY, NOUNLOAD,  STATS = 10;
GO

RESTORE LOG [sampledb] FROM  DISK = N'C:\backups\sampledb\pitr_tlog.bkp' WITH NORECOVERY, FILE=1, NOUNLOAD,  STATS = 10;
GO

RESTORE LOG [sampledb] FROM  DISK = N'C:\backups\sampledb\pitr_tlog.bkp' WITH NORECOVERY, FILE=2, NOUNLOAD,  STATS = 10;
GO

RESTORE LOG [sampledb] FROM  DISK = N'C:\backups\sampledb\pitr_tlog.bkp' WITH RECOVERY, FILE=3, NOUNLOAD,  STATS = 10, STOPAT='2008-05-28 11:58:09.680';
GO

ALTER DATABASE sampledb SET MULTI_USER WITH ROLLBACK IMMEDIATE;
GO

SELECT * FROM sampledb.dbo.sample;