Sybase ASE – Load Database from a Cross-Platform Dump File using sp_post_xpload
If you’re loading a database from another O/S, not only does the dump file need to be created in a quiesced state, but after the load we need to issue the sp_post_xpload command to rebuild any corrupted indexes that maybe present. Start by loading the database as usual:- load database <DB Name> from “compress::<Dumpfile_Path_and_Filename>”go You’ll…