RESTORE FileListOnly FROM DISK - no files
jm53671
Posts: 4
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.
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.
Comments
Error, "Failed to read file list from backup file. SQL Backup exit code : 5270 SQL error code : 0"
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8
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?