asked on

CANT Load database from server a to server B

Hi,
I have 2 Sybase servers 12.0.x
I want to reproduce a database from a to b
On ServerA:
Dump the database

sp_helpdb PROD

PROD 250

device 200
device_log 50

On ServerB:

Drop the database
create database PROD
on data=200
log on logdata=50
for load

when I load the database

load database PROD from "/tmp/PROD.dmp"

I got an error message :

Feb 21 12:19:36 2003: Backup Server: 1.14.2.4: Unrecoverable I/O or volume error. This DUMP or LOAD session must exit.
Feb 21 12:18:55 2003: Backup Server: 6.28.1.1: Dumpfile name 'RSystem030510F652' section number 1 mounted on disk file '/tmp/PROD.dmp'
Feb 21 12:18:56 2003: Backup Server: 1.1.2.26: Memory allocation failed in bs_remap_runlist for a M_IO_LIST allocation. This DUMP or LOAD session must exit.
Feb 21 12:18:56 2003: Backup Server: 6.32.2.3: /tmp/PROD.dmp: volume not valid or not requested (server: , session id: 104.)

I dont know whats wrong ?

thanks for the help

abidar

ASKER

I found the problem :O(((
It was because I was ftp using Binary instead of Ascii...

But I have another problem :
1> select u.uid,u.suid,u.name,l.suid,l.name from sysusers u, mast
2> where u.name=l.name
3> order by u.suid
4> go
uid suid name suid
name
------ ------ ------------------------------ ------
------------------------------
4 5 nsa 5
nsa

1> select u.uid,u.suid,u.name,l.suid,l.name from sysusers u, master..syslogins l
2> where u.name=l.name
3> order by u.suid
4> go
uid suid name suid name
------ ------ ------------------------------ ------ ------------------------------
3 -99 Admin 27 Admin

(2 rows affected)

How do I modify the suid

ASKER CERTIFIED SOLUTION

vka3

membership

This solution is only available to members.

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

Start Free Trial

leonstryker

No comment has been added to this question in more than 21 days, so it is now classified as abandoned..
I will leave the following recommendation for this question in the Cleanup topic area:

Answered vka3

Any objections should be posted here in the next 4 days. After that time, the question will be closed.

leonstryker
EE Cleanup Volunteer