Convert fails when executing from T-SQL

lhallacylhallacy Posts: 7
edited November 22, 2010 11:26AM in SQL Backup Previous Versions
When we execute the following command we get a 840 return code (File validation failed: E:\mssql\BACKUPS\AtSchool\AtSchool1.sqb). This command works fine on other servers.

-- Convert New backup
EXECUTE master..sqlbackup '-SQL "CONVERT ''E:\mssql\BACKUPS\AtSchool\AtSchool1.sqb'' TO ''E:\mssql\BACKUPS\AtSchool\atschool1.bak'' "'

Complete Return info:

Verifying...
File validation failed: E:\mssql\BACKUPS\AtSchool\AtSchool1.sqb


SQL Backup exit code: 840
· Share on Twitter

Comments

  • peteypetey Posts: 2,358 New member
    Are you by any chance using SQL Backup 5 to try to convert a backup created using SQL Backup 6?

    Thanks.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
  • lhallacylhallacy Posts: 7
    No the version we are using is 6.4.0.56 (sorry should have included that before).

    The backup and convert are both executed on the same server using the version referenced above. Here is the Script executing the backup command:

    -- backup Database
    EXECUTE master..sqlbackup '-SQL "BACKUP DATABASE AtSchoolLookups TO DISK = ''E:\mssql\BACKUPS\AtSchool\AtSchool1.sqb'' WITH DISKRETRYINTERVAL = 30, DISKRETRYCOUNT = 10,init, MAXDATABLOCK = 524288"'
    · Share on Twitter
  • peteypetey Posts: 2,358 New member
    What is the output when you run the following:
    EXEC master..sqlbackup '-sql "RESTORE SQBHEADERONLY FROM DISK = [E:\mssql\BACKUPS\AtSchool\AtSchool1.sqb]"'
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
Sign In or Register to comment.