Paul,

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?

Thanks.