How do i get restore succeed according to the code below?

Question

How do i get restore succeed according to the code below?

thinknight

SSCrazy

Points: 2068
More actions
July 13, 2010 at 7:46 am

#223769

How could i know just restore succeeded?
According to this code:
declare
@qStr varchar(512),
@i int
set @qStr = 'RESTORE DATABASE ...'
EXEC @i = sp_executesql @qStr
PRINT @i
Fails....

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 398909 More actions · Answer 1

thinknight (7/13/2010)
How could i know just restore succeeded?
According to this code:
declare
@qStr varchar(512),
@i int
set @qStr = 'RESTORE DATABASE ...'
EXEC @i = sp_executesql @qStr
PRINT @i
Fails....

You're not using standard syntax for the restore operation at all. Here is the full syntax for the restore operation.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

thinknight SSCrazy Points: 2068 More actions · Answer 2

I just want to verify restore operation finished successfully? How do i get result of restore with t-sql scripts?

sturner SSC-Insane Points: 22411 More actions · Answer 3

Use try - catch

The probability of survival is inversely proportional to the angle of arrival.

thinknight SSCrazy Points: 2068 More actions · Answer 4

Yes it is the correct solution. TRY..CATCH how do i not apply this?

Thanks 🙂