How can we help you today? How can we help you today?

Using with checksum option

I would like to use the checksum option with the , but am unable to get to work.

I am trying the following command, using the extended stored procedure:

exec master.dbo.sqlbackup '-SQL "BACKUP DATABASE pubs TO DISK = [C:\temp\Test_Checksum\pubs] WITH CHECKSUM"'

Without the "WITH CHECKSUM" the backup runs fine, but if I add it I get the following error:
SQL error 155: 'CHECKSUM' is not a recognized BACKUP option.

The documentation seems to suggest that "WITH CHECKSUM" is a valid option. Is there something wrong with my syntax, or am I missing something else altogether?

Thanks.
rt
0

Comments

1 comment

Sort by
  • petey
    You need to be using SQL Server 2005 in order to use the CHECKSUM option. We'll update the documentation to make that clearer.
    petey
    0

Add comment

Please sign in to leave a comment.