Load database command returns incorrect syntax error

[cch868]

Can someone please help me?!?! I have a customer that dumped their database using striping. They provided their striped dump files which I have on a network drive that is mapped to the server on which I want to load the data into a new Sybase database. I am using a load file from a command prompt with the following syntax:

use master
go
load database NEW_DB from
'g:\backup\dbdmp.20030406220337.s1'
stripe on 'g:\backup\dbdmp.20030406220337.s2'
stripe on 'g:\backup\dbdmp.20030406220337.s3'
stripe on 'g:\backup\dbdmp.20030406220337.s4'
stripe on 'g:\backup\dbdmp.20030406220337.s5'
stripe on 'g:\backup\dbdmp.20030406220337.s6'
stripe on 'g:\backup\dbdmp.20030406220337.s7'
stripe on 'g:\backup\dbdmp.20030406220337.s8'
stripe on 'g:\backup\dbdmp.20030406220337.s9'
stripe on 'g:\backup\dbdmp.20030406220337.s10'
stripe on 'g:\backup\dbdmp.20030406220337.s11'
go

When I run this I get the following error:

1> 2> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> Msg 170, Level 15, State
1, Server NTSERVEREV01, Line 2
Line 2: Incorrect syntax near
'g:\backup\dbdmp.20030406220337.s1'.
1>


Does anyone have any idea what the syntax error could be or what I am doing wrong? Thanks!

 

[sybaseguru]

I do not know much about NT but can you change the backslash to "/" and try again. Also Msg 170, I cannot find any reference to it in troubleshooting guide

 

[cch868]

I tried changing the \ to / and received the same error message of invalid syntax. Any other suggestions?!?!?!

 

[sybaseguru]

1) check backup server errorlog first for any messages

2) Try to see you can dump model database to g drive.

dump database model to 'g:/backup/model.dmp'

If OK then backup server can see g drive OK.

3) may be dump filenmaes are too long. rename them to "dbdump.stripe1" as opposed to dbdmp.20030406220337.s1