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
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!