–1 use master backup database logTest to disk=’D:\\Program Files\\Microsoft SQL Server\\MSSQL10.MSSQLSERVER\\MSSQL\\Backup\\logTest.bak’ with format –2 use logTest create table table_1(Id int, test varchar(max)) insert table_1(Id,test) va
–1 use master backup database logTest to disk=’D:\\Program Files\\Microsoft SQL Server\\MSSQL10.MSSQLSERVER\\MSSQL\\Backup\\logTest.bak’ with format –2 use logTest create table table_1(Id int, test varchar(max)) insert table_1(Id,test) values (1,’3333′); insert table_1(Id,test) values (2,’4333′); insert table_1(Id,test) values (3,’5333′); use master –2.1 WAITFOR DELAY ’00:00:05′ GO use logTest truncate table table_1 select GETDATE() use master –3 use master backup log logTest to disk=’D:\\Program Files\\Microsoft SQL Server\\MSSQL10.MSSQLSERVER\\MSSQL\\Backup\\logTest_log.bak’ with format –4 –DECLARE @dt datetime –SELECT @dt=DATEADD(ms,-1800,GETDATE()) –select @dt restore database logtest from disk = ‘D:\\Program Files\\Microsoft SQL Server\\MSSQL10.MSSQLSERVER\\MSSQL\\Backup\\logTest.bak’ WITH REPLACE RESTORE LOG logTest FROM DISK=’D:\\Program Files\\Microsoft SQL Server\\MSSQL10.MSSQLSERVER\\MSSQL\\Backup\\logTest_log.bak’ with STOPAT= ‘2009-10-26 12:38:57.133’ GO
