sql 恢复指定文件夹下的所有日志文件。

DECLARE @Path nvarchar(260)SET @Path = 'D:/backup/back_data/LOG/TEST'IF RIGHT(@Path, 1) <> '/'SET @Path = @Path + '/'IF OBJECT_ID('tempdb..#') IS NOT NULLDROP TABLE #CREATE TABLE #(id int IDENTITY,directory nvarchar(260),depth int,IsFile bit)INSERT # EXEC master.dbo.xp_dirtree @path = @path,@depth = 0,@file = 1DECLARE @depth int, @depthMax intUPDATE # SET directory = @Path + directory WHERE depth = 1DECLARE @RestorePath nvarchar(4000)DECLARE C CURSOR FOR SELECT directory FROM #OPEN C FETCH NEXT FROM C INTO @RestorePath WHILE @@FETCH_STATUS=0BEGIN RESTORE LOG back_data FROM DISK=@RestorePath WITH NORECOVERY FETCH NEXT FROM C INTO @RestorePath ENDCLOSE CDEALLOCATE C