Shulou(Shulou.com)05/31 Report--

This article mainly explains the "sqlserver log recovery method", the content of the article is simple and clear, easy to learn and understand, now please follow the editor's train of thought slowly in depth, together to study and learn "sqlserver log recovery method"!

-- 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); insert table_1 (Id,test) values (2); insert table_1 (Id,test) values (3) Use master-2.1 WAITFOR DELAY '00VOV 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 1238 Microsoft SQL Server 57.133' GO Thank you for your reading The above is the content of "sqlserver log recovery method". After the study of this article, I believe you have a deeper understanding of the sqlserver log recovery method, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.