Using with checksum option
rt
Posts: 2
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.
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
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8