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