SQL Server log recovery method (handle drop and truncate) _mssql

--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