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>
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>