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

Convert fails when executing from T-SQL

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
lhallacy
0

Comments

3 comments

Sort by
  • petey
    Are you by any chance using SQL Backup 5 to try to convert a backup created using SQL Backup 6?

    Thanks.
    petey
    0
  • lhallacy
    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"'
    lhallacy
    0
  • petey
    What is the output when you run the following:
    EXEC master..sqlbackup '-sql "RESTORE SQBHEADERONLY FROM DISK = [E:\mssql\BACKUPS\AtSchool\AtSchool1.sqb]"'
    petey
    0

Add comment

Please sign in to leave a comment.