In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-09-23 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
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.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
The market share of Chrome browser on the desktop has exceeded 70%, and users are complaining about
The world's first 2nm mobile chip: Samsung Exynos 2600 is ready for mass production.According to a r
A US federal judge has ruled that Google can keep its Chrome browser, but it will be prohibited from
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
About us Contact us Product review car news thenatureplanet
More Form oMedia: AutoTimes. Bestcoffee. SL News. Jarebook. Coffee Hunters. Sundaily. Modezone. NNB. Coffee. Game News. FrontStreet. GGAMEN
© 2024 shulou.com SLNews company. All rights reserved.