Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 How can i the result of restore w/t-sql scripting

Author  Topic 

thinknight
Starting Member

3 Posts

Posted - 2010-07-13 : 10:30:21
How do i get the result of restore, How do i verify restore finished successfully?

declare
@qStr varchar(512),
@i int

set @qStr = 'RESTORE DATABASE ...'
EXEC @i = sp_executesql @qStr
PRINT @i

Kristen
Test

22859 Posts

Posted - 2010-07-13 : 10:52:21
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=54300
Go to Top of Page
   

- Advertisement -