Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Attempt to read a dump header failed

Status
Not open for further replies.

cch868

Programmer
Sep 29, 2000
5
US
Hello all. I got past my previous incorrect syntax error but now I am running into a new one. If anyone has seen this or has any suggestions for a resolution, I would really appreciate it. Thanks in advance!! I am trying to import a database from a striped dump file. When I run the import command I am getting an odd error. What follows is the load command syntax and the resulting error. Again, any help would be much appreciated as I have not seen this one before!!

1> use master
2> go
1> load database NEWDB from
2> 'E:\DATA\data\newdb.dbdmp.20030406220337.s1'
3> stripe on 'E:\DATA\data\newdb.dbdmp.20030406220337.s2'
4> stripe on 'E:\DATA\data\newdb.dbdmp.20030406220337.s3'
5> stripe on 'E:\DATA\data\newdb.dbdmp.20030406220337.s4'
6> stripe on 'E:\DATA\data\newdb.dbdmp.20030406220337.s5'
7> stripe on 'E:\DATA\data\newdb.dbdmp.20030406220337.s6'
8> stripe on 'E:\DATA\data\newdb.dbdmp.20030406220337.s7'
9> stripe on 'E:\DATA\data\newdb.dbdmp.20030406220337.s8'
10> stripe on 'E:\DATA\data\newdb.dbdmp.20030406220337.s9'
11> stripe on 'E:\DATA\data\newdb.dbdmp.20030406220337.s10'
12> stripe on 'E:\DATA\data\newdb.dbdmp.20030406220337.s11'
13> go
Backup Server session id is: 19. Use this value when executing the
'sp_volchanged' system stored procedure after fulfilling any volume change
request from the Backup Server.
Backup Server: 6.28.1.1: Dumpfile name 'newdb030961364C' section number 1
mounted on disk file 'E:\DATA\data\newdb.dbdmp.20030406220337.s1'
Backup Server: 6.28.1.1: Dumpfile name 'newdb030961364C' section number 1
mounted on disk file 'E:\DATA\data\newdb.dbdmp.20030406220337.s7'
Backup Server: 6.28.1.1: Dumpfile name 'newdb030961364C' section number 1
mounted on disk file 'E:\DATA\data\newdb.dbdmp.20030406220337.s5'
Backup Server: 6.28.1.1: Dumpfile name 'newdb030961364C' section number 1
mounted on disk file 'E:\DATA\data\newdb.dbdmp.20030406220337.s6'
Backup Server: 6.28.1.1: Dumpfile name 'newdb030961364C' section number 1
mounted on disk file 'E:\DATA\data\newdb.dbdmp.20030406220337.s8'
Backup Server: 6.28.1.1: Dumpfile name 'newdb030961364C' section number 1
mounted on disk file 'E:\DATA\data\newdb.dbdmp.20030406220337.s9'
Backup Server: 6.28.1.1: Dumpfile name 'newdb030961364C' section number 1
mounted on disk file 'E:\DATA\data\newdb.dbdmp.20030406220337.s2'
Backup Server: 6.28.1.1: Dumpfile name 'newdb030961364C' section number 1
mounted on disk file 'E:\DATA\data\newdb.dbdmp.20030406220337.s3'
Backup Server: 6.28.1.1: Dumpfile name 'newdb030961364C' section number 1
mounted on disk file 'E:\DATA\data\newdb.dbdmp.20030406220337.s4'
Backup Server: 6.28.1.1: Dumpfile name 'newdb030961364C' section number 1
mounted on disk file 'E:\DATA\data\newdb.dbdmp.20030406220337.s10'
Backup Server: 6.28.1.1: Dumpfile name 'newdb030961364C' section number 1
mounted on disk file 'E:\DATA\data\newdb.dbdmp.20030406220337.s11'
Msg 3223, Level 20, State 1:
Line 1:
Attempt to read a dump header failed; returned error code is 10.
Msg 3208, Level 16, state 1:
Line 1:
Unexpected end of file while reading beginning of dump. Please confirm
that
dump media contains a valid SQL Server dump. The SQL Server error log may
contain more information on the problem.
1>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top