SQL Server数据恢复

11:47:00 insert

 

create table Student(id int ,name nvarchar(50))
insert into Student(id,Name)
select 1,'a'
union all
select 2,'b'
union all
select 3,'c'
union all
select 4,'d'

 

11:49:00 drop table

Drop table Student

use [master]
BACKUP LOG [Test] TO disk= N'f:\Test_Log.bak' WITH NORECOVERY

RESTORE DATABASE [Test] FROM DISK = N'f:\Test_Full.bak' WITH NORECOVERY, REPLACE --使用之前的完整备份

RESTORE LOG [Test] FROM DISK = N'f:\Test_Log.bak' WITH STOPAT = N'2014-11-12 11:21:05' , RECOVERY