What are the challenges you face when working across database platforms? Take the survey
Options

RESTORE FileListOnly FROM DISK - no files

jm53671jm53671 Posts: 4
edited March 23, 2006 4:11PM in SQL Backup Previous Versions
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.

Comments

Sign In or Register to comment.