I have a few automated backups running in various places.
They typically are started via a .bat file launching sqlcmd.exe with the -i parameter pointing to the .sql file issuing the backup command.
The occassional restore I had to do never presented a problem. But I prefere to be on the safe side.
Once I have put the WITH CHECKSUM into the .sql file, how is an error signaled?
What sort of message is generated? If so, I suppose it's in the sqlcmd.exe output which I would have to pipe into a log.
Does sqlcmd.exe return a DOS error code of some sort in this case?