Oct 11 22:36:58 2017: Backup Server: 6.35.2.2: Volume validation error: bad magic number EOF1, expected USTH.
Oct 11 22:36:58 2017: Backup Server: 6.32.2.3: compress::/sybase/dump/Database.20171011.14.DB::013: volume not valid or not requested (server: , session id: 72.)
Currently, I am working on migrating a Sybase server to a new host and I installed a higher version of Sybase on that host. When I tried to LOAD the Database DUMP from the current server I got the above error.
All the help that I got online pointed towards the cause being that the version where I took the backup was at a higher level than where I was loading to. But that was not the case.
Then I started working on a uncompressed dump file that seemed to do the trick. However, the production database was so large that I didn't have enough disk space to take an uncompressed dump file.
So next I tried to use the native option for compression in the LOAD command
dump database mydb "/sybase/dump/database.dmp"
with compression = "9"
This seemed to do the trick. I had actually dumped to multiple stripes so I had to modify the above command.
To test this further I tried it without the compression option that too seemed to work.
So try this too
dump database mydb "/sybase/dump/database.dmp"
Oct 11 22:36:58 2017: Backup Server: 6.32.2.3: compress::/sybase/dump/Database.20171011.14.DB::013: volume not valid or not requested (server: , session id: 72.)
Currently, I am working on migrating a Sybase server to a new host and I installed a higher version of Sybase on that host. When I tried to LOAD the Database DUMP from the current server I got the above error.
All the help that I got online pointed towards the cause being that the version where I took the backup was at a higher level than where I was loading to. But that was not the case.
Then I started working on a uncompressed dump file that seemed to do the trick. However, the production database was so large that I didn't have enough disk space to take an uncompressed dump file.
So next I tried to use the native option for compression in the LOAD command
dump database mydb "/sybase/dump/database.dmp"
with compression = "9"
This seemed to do the trick. I had actually dumped to multiple stripes so I had to modify the above command.
To test this further I tried it without the compression option that too seemed to work.
So try this too
dump database mydb "/sybase/dump/database.dmp"
No comments:
Post a Comment