asked on

Dump from another machine fails to restore

I can connect to the machine remotely that performed the dump, although I do not have (or know of) a method by which I can get a dump from that remote machine to my local machine. In my SQL Central interface (version 11.x), I am connected to the remote server, REMOTE01. The admin said he used the isql DUMP command to dump the data from database abcdefgh on that server. The filename is 011205.dat and it is roughly 26 MB.

There are several partitions on that database:

Dialog box error that occurs when performing restore from Backup on the 'abcdefgh' database residing on LOCAL01:
-----------------------------
LOCAL01
Backup Server session id is: 5. (*** this number varies on each iteration ***). 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 'bcdefgh050120C908'section number 0001 mounted on disk file 'c:\sybase\data\011205.dat' (although I have put in fake names, I have mirrored the letter patterns...notice the dumpfile name began with bcd instead of abc...I assume this is normal??)
Backup Server: 4.58.1.1: Database abcdefgh: 2948 kilobytes LOADed.
Backup Server: 4.58.1.1: Database abcdefgh: 7680 kilobytes LOADed.
Backup Server: 4.58.1.1: Database abcdefgh: 21258 kilobytes LOADed.
Backup Server: 4.58.1.1: Database abcdefgh: 25398 kilobytes LOADed.
Backup Server: 4.58.1.1: Database abcdefgh: 37378 kilobytes LOADed.
Backup Server: 4.58.1.1: Database abcdefgh: 80896 kilobytes LOADed.
Backup Server: 4.58.1.1: Database abcdefgh: 123906 kilobytes LOADed.
Backup Server: 4.58.1.1: Database abcdefgh: 167424 kilobytes LOADed.
Backup Server: 4.58.1.1: Database abcdefgh: 179200 kilobytes LOADed.
Attempt to read a dump trailer failed; returned error code is 6.
The Backup Server encountered an invalid dump trailer page, so SQL Server is not able to correctly recover database 'abcdefgh'. Because of this error, the database is now suspect.
-----------------------------

This is the error that I believe is killing my load.
Subsequently, another dialog box displays with the information below:

-----------------------------
LOCAL01
Database 'abcdefgh' cannot be opened because either an earlier system termination left LOAD DATABASE incomplete or the database is created with 'for load' option. Load the database or contact a user with System Administrator (SA) role.
-----------------------------

Here is the info from the Sybase Tools Console (v2.0)

-------------------------------------------------
Backup Server session id is: 5. Use this value when executing the 'sp_volchanged' system stored procedure after fulfilling any volume change request from the Backup Server.
Backup Server: 6.32.2.4: c:\sybase\data\011205.dat: volume not valid or not requested (server: , session id: 5.)
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error. This DUMP or LOAD session must exit.

Backup Server: 6.32.2.3: c:\sybase\data\011205.dat: volume not valid or not requested (server: , session id: 5.)

Backup Server: 1.14.2.4: Unrecoverable I/O or volume error. This DUMP or LOAD session must exit.

Backup Server session id is: 7. 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 'bcdefgh050120C908' section number 0001 mounted on disk file 'c:\sybase\data\011205.dat'
Backup Server: 4.58.1.1: Database abcdefgh: 2948 kilobytes LOADed.

Backup Server: 4.58.1.1: Database abcdefgh: 7680 kilobytes LOADed.

Backup Server: 4.58.1.1: Database abcdefgh: 21258 kilobytes LOADed.

Backup Server: 4.58.1.1: Database abcdefgh: 25398 kilobytes LOADed.

Backup Server: 4.58.1.1: Database abcdefgh: 37378 kilobytes LOADed.

Backup Server: 4.58.1.1: Database abcdefgh: 80896 kilobytes LOADed.

Backup Server: 4.58.1.1: Database abcdefgh: 123906 kilobytes LOADed.

Backup Server: 4.58.1.1: Database abcdefgh: 167424 kilobytes LOADed.

Backup Server: 4.58.1.1: Database abcdefgh: 179200 kilobytes LOADed.

-------------------------------------

Now...here are the contents of the REMOTE01's sp_helpdb abcdefgh

-------------------------------------
device_fragments size usage free kbytes
------------------------------ ------------- -------------------- -----------
defgh_data 20.0 MB data and log 7824
defgh_data 55.0 MB data and log 56320
defgh_data 5.0 MB data only 0
defgh_data 5.0 MB data only 16
defgh_data 5.0 MB log only 0
defgh_data 5.0 MB log only 5120
defgh_data 5.0 MB log only 3184
defgh_log 75.0 MB log only 76800
-------------------------------------

Next are the device fragments for the local I created (I tried initially to create the same set of devices shown immediately above, but could not get it to allocate the space in the same portions...not sure if this is part of the problem or not).

-------------------------------------
device_fragments size usage free kbytes
------------------------------ ------------- -------------------- -----------
defgh_data 100.0 MB data only 101600
defgh_log 75.0 MB log only 76784
master 2.0 MB data only 2048
master 2.0 MB data only 2048
--------------------------------------

And now for the plea....
HELP!!! I have two goals, the first of which is likely the most important....
(1) get the remote data imported into my local so I can have a local copy of the data to work with while disconnected
(2) get the remote data imported into MS SQL Server 7 or 2000.

Note: The names of the servers and databases were changed...in case I missed any, the remote and local db have the same db name, but the remote and local sybase server names are different. I can connect to the remote and to the local, and I can start the _BS and _MS servers. I cannot browser the local _BS or local _MS servers...I can only start/stop them. I cannot see the remote _BS or _MS servers.

This has stumped me since Friday; please help.

Ross

rosspg

ASKER

I just performed a version compare at the isql command window...the first set is from the local, and the second set is from the remote...apparently my versions are different. Would this be a showstopper on the data dump? If so, how else can I export it in a compatible fashion for the local version 11.0.2?
C:\sybase\DATA>isql -SLOCAL01 -Usa
1> @@version
2> go
Msg 7218, Level 11, State 2:
Line 1:
Site 'SQL Server/11.0.2' not found in sysservers.
1> quit

C:\sybase\DATA>isql -SREMOTE01 -Usa
Password:
1> @@version
2> go
Msg 7218, Level 11, State 2:
Line 1:
Site 'Adaptive Server Enterprise/11.9' not found in sysservers.
1>

SOLUTION

crnimajlo

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

Joe Woodhouse

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

rosspg

ASKER

I am going to check if the cust. has v. 11.9.x. I have used BCP just a tiny bit, but not in years. I would certainly appreciate tips/pointers on it should I need to fall back on that solution.

Thx,
Ross

rosspg

ASKER

Thanks to both of you...I was able to get the data successfully loaded, but the application requires different DLLs than those required and used for the running of a local database server. The app interacts with OpenStep and inside the index.eomodel it has the following beginning text...

{
EOModelVersion = 2.1;
adaptorName = Sybase;
connectionDictionary = {
databaseName = irmcnmoc;
hostName = REMOTE01;
password = "";
userName = "";
};

Is there a way I can tell it or trick it to have the applicable dlls in two different directories so that I can launch and interact with the db, but so that I can also connect as a client through the openstep app? Right now, if I have my normal dlls, I can start/shut my local server. If I put the app dlls, I can not start my server (and cannot start it before copying the dlls over it), but can connect to a remote server.

Thx,
Ross

Joe Woodhouse

I'm guessing from the directory paths you used in your examples above that you're running this from Windows.

If so, this is tricky, as Windows always implicitly searches the current directory first in its path.

If there are environment variables that your app uses to point to a directory, you might be able to have multiple BAT files that redefine the variables to point to two different directories.

Or, you could install the app twice in two different directories, and then copy the corresponding DLLs to the directories where the application EXE file(s) live - Windows always looks in the current directory of an EXE for its DLLs first before searching the path.

Good luck!

rosspg

ASKER

That's a good idea...I am also looking to see where they Sybase adaptor for OpenStep is defined to determine if I can alter it for the correct dll set...otherwise, I will try the second sybase instance install if Sybase will permit it with v11.9

I appreciate the ideas!!

Ross

Joe Woodhouse

Let us know how it works... good luck!