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

RESTORE FileListOnly FROM DISK - no files

In GUI get:
I see the header info, then when try to list file, get error message = Error, "Failed to read file list from backup file."


from Query Analyzer
--47 seconds for no rows returned (result set successful = 0 rows)
exec master..sqlbackup '-sql "RESTORE FileListOnly FROM DISK = [F:\3.1 Disaster\OPSDEPO_LRCS_FULL_3_1_abandoned.sqb]"'

--quick
exec master..sqlbackup '-sql "RESTORE SQBHEADERONLY FROM DISK = [F:\3.1 Disaster\OPSDEPO_LRCS_FULL_3_1_abandoned.sqb]"'

Have tried doing a new backup to folder, then listing header and filelist info. Is successful. Service account has full administrative rights.
jm53671
0

Comments

4 comments

Sort by
  • jm53671
    version 4 gui returns message of:
    Error, "Failed to read file list from backup file. SQL Backup exit code : 5270 SQL error code : 0"
    jm53671
    0
  • jm53671
    3.0 can read the files w/i the backup. It appears to be restoring right now. Not really a difficulty I would have expected....
    jm53671
    0
  • petey
    Would it be possible to send us the backup file, or a similar one where version 4 fails to read the file list?
    petey
    0
  • Brian Donahue
    Hi Peter,

    On a similar note, erasefiles didn't erase the files created with v3 after we upgraded to v4 on our production server. Maybe v4 has some problems reading v3 backup headers?
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.