Activity overview
Latest activity by moose
I tried the v5.2 sqlbackupc and sqb2mtf. The problem still persists. I was not sure if v5.2 was still in beta, or if it has gotten to production release, and as such was completing the rollout of this product before upgrading to the next version.
Thanks / comments
I tried the v5.2 sqlbackupc and sqb2mtf. The problem still persists. I was not sure if v5.2 was still in beta, or if it has gotten to production release, and as such was completing the rollout of t...
You could try something along these lines, setting the variables with the required options for your environment.
declare @... nvarchar(4000), @backup_name varchar(500), @exitcode int, @sqlerrorcode int,name varchar(128),@from_dir varchar(1000),@done_dir varchar(1000), @error_email varchar(1000)
set @sql='DECLARE @exitcode int;DECLARE @sqlerrorcode int;EXECUTE master..sqlbackup N''-SQL '
set @sql=@... + '"BACKUP DATABASE TO DISK = ''''' + @from_dir + @backup_name + ''
set @sql=@... + ''''' WITH COPYTO = ''''' + @done_dir + ''''', ERASEFILES = 5, '
set @sql=@... + 'MAILTO_ONERROR = ''''' + @error_email + ''''', NORECOVERY"'', @exitcode OUT, @sqlerrorcode OUT'
exec sp_executesql @... / comments
You could try something along these lines, setting the variables with the required options for your environment.
declare @... nvarchar(4000),@backup_name varchar(500),@exitcode int,@sqlerrorcode in...
I have some more information on this issue. After cancelling the sqb2mtf process that had hung (by using control-C), I noticed that the 3 files that were created by this process were still on the filesystem. I was able to set up a test copy of this database and rolled the backups up to this log file. I then used the mtf files and SQL Server Native restore and was able apply this (failing) transaction log. Then I was able to apply the next sequential log file using sql backup restore (this one had not been failing), and perform a recovery and the database was able to be brought online without issue. I also performed a dbcc checkdb on the temp db and it was fine. So it appears as though there is some sort of issue with the verify,restore and convert applications with respect to this file. Is this an issue with my setup or something else? / comments
I have some more information on this issue. After cancelling the sqb2mtf process that had hung (by using control-C), I noticed that the 3 files that were created by this process were still on the f...
Transaction Log File Broken
I have come accross the following problem:
A transaction log backup was created and there were no issues reported with the backup. When I try to restore from this file it appears to run indefinitel...