January 16, 2004 at 4:08 am
Hi a little while ago I posted a topic on how to resond to verifyonly, and the answer was:
restore verifyonly FROM DISK = 'db dump'
if @@error = 3013 --3013 = not a valid backup set.
begin
--retry backup one more time!
end
However verify takes a little too long on very large databases and you can establish even quicker if it is OK if you use a,
"restore verifyonly FROM DISK = 'db dump' "
and look at the BackupName. If it says
*** INCOMPLETE ***
then it has failed. Any ideas though as to how I could respond to this, i.e. have a query which said
if backupName= %incomplete% then job_step = failed
else job_step = success
Ideas as always much appreciated! Rob
January 16, 2004 at 5:49 am
You mean "RESTORE HEADERONLY FROM DISK = 'db dump'" of course.
Create a temporary table with the same column types as the result set from the command. Then
INSERT #TempBU
EXEC('RESTORE HEADERONLY FROM DISK = ''db dump''')
IF EXISTS (SELECT * FROM #TempBU WHERE BackupName LIKE '%INCOMPLETE%')
...
--Jonathan
January 16, 2004 at 7:07 am
Thanks Jonathon,
I thought it might be something like that I was just wondering if you could respond to an @@error or something. Do you think you could use a table variable for this instead of a temp table?
Rob
January 16, 2004 at 8:43 am
If there's an error thrown, I think it would be documented.
You can't insert into a table variable using EXEC.
--Jonathan
February 8, 2007 at 1:10 am
me too we have the same problem.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply