Competition: What’s your favorite Redgate tool? Enter now.

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

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
  • 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"'
  • 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
Sign In or Register to comment.