What are the challenges you face when working across database platforms? Take the survey
Options

Using with checksum option

rtrt Posts: 2
edited June 25, 2007 10:23PM in SQL Backup Previous Versions
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.

Comments

  • Options
    peteypetey Posts: 2,358 New member
    You need to be using SQL Server 2005 in order to use the CHECKSUM option. We'll update the documentation to make that clearer.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.