阿里云sqlserver 迁移到百度云sqlserver 2

use master
go
create procedure RestoreDBLog(   @LogPath varchar(200),
  @DBName varchar(200)
  )

  --exec RestoreDBLog ‘D:\DBBackup\log\testex\‘,‘testexlog‘
  as 
begin
declare @SqlStr varchar(2000),@file_timestamp varchar(50)
declare @Physical_Device_Name nvarchar(200)
declare @TimeBigint bigint
declare @FileName varchar(256)
declare @sql nvarchar(2000)
declare @LogPathGet nvarchar(200)


set @SqlStr = ‘dir ‘ + @LogPath  + ‘\ /B‘

create table #FileName([filename] varchar(200))

insert into #FileName exec master..xp_cmdshell @SqlStr
delete from #FileName where filename is null
delete from #FileName where filename like ‘%.txt‘

alter table #FileName add TimeBigint bigint,RestoreStatus int
update #FileName set TimeBigint=cast(left(right([filename],21),17) as bigint),RestoreStatus=0
   set @LogPathGet=@LogPath+‘%‘
   select @LogPathGet
   set @sql=N‘select top 1 @Physical_Device_Name=physical_device_name from msdb.dbo.backupmediafamily with(nolock) where physical_device_name like @LogPathGet order by media_set_id desc‘   
   exec sp_executesql @sql,N‘@LogPathGet NVARCHAR(200),@Physical_Device_Name nvarchar(200) OUTPUT‘,@LogPathGet,@Physical_Device_Name OUTPUT;
   select @Physical_Device_Name
 delete from #FileName where TimeBigint <= cast(left(right(@Physical_Device_Name,21),17) as bigint)
   set @SqlStr	=‘‘
   	while exists (select  * from #FileName where RestoreStatus=0 )
	
			begin				 
				select top 1 @FileName=FileName,@TimeBigint=TimeBigint from 
				       #FileName where  RestoreStatus = 0 order by TimeBigint
                set @SqlStr	 =‘restore database ‘ + @DBName + ‘ from disk = ‘+‘‘‘‘ + @logpath  + @FileName +‘‘‘‘+‘ with norecovery‘	
				
				select 	@FileName,	    @TimeBigint
				print (@SqlStr)
				exec(@SqlStr)
				
				update #FileName set RestoreStatus = 1 where TimeBigint = @TimeBigint
		
				set @SqlStr=‘‘
				if not exists (select  * from #FileName where RestoreStatus=0)				             
				begin
					set @SqlStr = ‘restore database ‘ + @DBName + ‘ with standby=‘+‘‘‘‘+ @LogPath+ @DBName + ‘.txt‘+‘‘‘‘
					exec(@SqlStr)
                    break
			     end
	         end
			 
		 drop table #FileName

--set @sql=‘forfiles /p D:\DBbackup\log\ /m *.trn /d -2 /s /c "cmd /c if @ISDIR==FALSE DEL /A A @FILE && Echo @path"‘
--exec master..xp_cmdshell @sql
end