sqlserver 日志恢复方法(搞定drop和truncate)

–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′); in