Hi Guys!

when I run this module to my database refresh job it runs good but when it get any bad backup file the job quit and shows the same error...

Hi!

Instead of giving database path I want to give database name by using parameter. Itried following script

DECLARE @vcText int

,@db varchar(50)

set @db='msdb'

EXEC @vcText = master..xp_restore_verifyonly @filename='\\ctsqladp01\Backup$\InstA\'+@db+'.lsb'

But It shows the error below:

Msg...

Hi Dave!

Now I am getting the following Error. It runs but showing some extra error messagw which I try to avoid.Any Idea?

Msg 536, Level 16, State 5, Line 5

Invalid length...

Hi Dave!

I got following error from your modified script

Msg 102, Level 15, State 1, Line 6

Incorrect syntax near ')'.

It looks to me okay. But something is wrong there. Here i...

Right I just want to grab 50204 for testing further conditions not the error text.

Thank you.

Mohammad Aziz

If I run th following command(for good DB):

create table #a ( aline varchar(max))

DECLARE @vcText varchar(200)

EXEC @vcText = master..xp_restore_verifyonly @filename='\\ctsqladp01\Backup$\InstA\msdb.lsb'

INSERT INTO #a (aline)

VALUES (@vcText)

if exists (select * from #a where aline='0')

BEGIN

print...

Exactly, Can you give me more details please.

Thank you.

Mohammad

Hi Dave!

I appreciate your help. But the command return text message which I need to capture for my further analysis. This query shows 0 if the backup file is good...

Hi Adam!

your previous query doesn't show any error, that shows empty table that is not contain any data. And your modified query shows all the log information. Can you tell...

I tried this before that doesn't work.

Thank you.

Mohammad Aziz