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

版权声明：本文为siso原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://www.cnblogs.com/siso/p/4091910.html