Home > IT Answers > SQL Server > Using the return value of a SQL Restore script
SQL Server Ask the Experts
2,585 pts.
 Using the return value of a SQL Restore script
SQL Restore, SQL Server, SQLCMD
I am trying to use the return value of a SQL Restore script executed with SQLCMD, so that my batch script can report on the succes or failure of the restore. I am having difficulty getting the script to return the result of the backup or restore process. Do you have any suggestions? The follwoing succesfully restores the database but returns a -100 error code: 
SQLCMD -S SERVERNAME -Q "exit(RESTORE DATABASE [PremiumAutomation] FROM  DISK = N'C:SQLBackupsHotBackupPremiumAutomationRest.bak' WITH  FILE = 1,  NOUNLOAD,  REPLACE,  STATS = 10)" -o FolderNameRestore.Log


Software/Hardware used:
ASKED: March 16, 2009  5:34 PM
UPDATED: March 20, 2009  11:27 AM
RELATED QUESTIONS
Answer Wiki:
You can use SQLCMD <b>-b</b> to return a nonzero exit code when the SQL batch fails. You can then check the ERRORLEVEL in the batch to determine if the outcome was succesfull
Last Wiki Answer Submitted:  March 20, 2009  11:27 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _