how to load sybase db from dump file

fiaola

unread,

Jul 21, 2008, 11:33:48 PM7/21/08

to

Hello,

I'm an newbie with Sybase database. I have a version 12.5 sybase database i
am trying to load on a test machine. I"m a complete idiot with Sybase and
don't know the first thing i need to do. If anyone want to assist me here,
i would be glad to pay for your time as I'm trying to trouble shoot an
urgent problem.

Please email me at teelea...@gmail.com if you are interested. Appreciate
any suggestion or direction to resources that can help me accomplish my
task.

Thank you very much for you help.

TL

Cory Sane

unread,

Jul 22, 2008, 2:48:54 AM7/22/08

to

The easiest load process is
load database [dbname] from "/path/dumpfile"

Cory Sane
[TeamSybase]

"fiaola" <fia...@mail.com> wrote in message news:4885551c@forums-1-dub...

fiaola

unread,

Jul 23, 2008, 9:26:15 PM7/23/08

to

I get an error saying, "can't open connection to site "syb.backup". The
backupserver is running.
Any sugesstions?

Thanks again.

"Cory Sane" <cory!=sane> wrote in message news:488582d6$1@forums-1-dub...

Cory Sane

unread,

Jul 23, 2008, 10:51:42 PM7/23/08

to

Your error should be for "syb_backup" (note the underscore)

If that is not the problem then it is time to start digging...
Find the entry master..sysservers and make sure that the SrvNetName column
points to an entry in the interfaces[or]sql.ini file in $SYBASE.

If those match then send us the sysservers row for syb_backup and the
interfaces definition that matches because we'll need to keep digging
deeper.

Please also send us the ASE version and platform information.

Cory Sane
[TeamSybase]
Certified Associate DBA for ASE 15.0

"fiaola" <fia...@mail.com> wrote in message news:4887da37@forums-1-dub...

ThanksButNo

unread,

Jul 24, 2008, 2:10:32 AM7/24/08

to

On Jul 23, 7:51 pm, "Cory Sane" <cory!=sane> wrote:
> Your error should be for "syb_backup" (note the underscore)
>

Assuming that's not a typo, it should be a simple matter to run
"sp_helpserver" and see if there exists a "SYB_BACKUP" server with a
"network_name" that matches the entry in the $SYBASE/interfaces file.
I believe the the all-caps is also important.

fiaola

unread,

Jul 24, 2008, 11:44:08 PM7/24/08

to

Thanks.

ASE 12.5 running on a windows 2000 server.

"Cory Sane" <cory!=sane> wrote in message news:4887ee3e@forums-1-dub...

fiaola

unread,

Jul 24, 2008, 11:57:34 PM7/24/08

to

The Dump file is from a 12.5 version.

I'm trying to load into a Developers Version 15, running on a windows 2000
server.

contents of the SQL.ini

[SERVER05_BS]
master=NLWNSCK, Server05,5001
query=NLWNSCK,Server05,5001

[SERVER05_MS]
master=NLWNSCK, Server05,5002
query=NLWNSCK,Server05,5002

[SERVER05_JSAGENT]
master=NLWNSCK, Server05,4900
query=NLWNSCK,Server05,4900

[ws]
master=NLWNSCK, Server05,8183
query=NLWNSCK,Server05,8183

[SERVER05]
master=NLWNSCK, Server05,5000
query=NLWNSCK,Server05,5000

[SERVER05_XP]
master=NLWNSCK, Server05,5004
query=NLWNSCK,Server05,5004

Thanks.

"Cory Sane" <cory!=sane> wrote in message news:4887ee3e@forums-1-dub...

fiaola

unread,

Jul 25, 2008, 12:06:32 AM7/25/08

to

Here is the content of the sysservers in the master.

1 8 SYB_BACKUP SYB_BACKUP
2 1024 SYB_EJB EJBServer
10
0 8 SNASAMAPS05 SNASAMAPS05 0
0
3 8 SNASAMAPS05_XP SNASAMAPS05_XP 11
1000
4 8 SYB_JSAGENT SNASAMAPS05_JSAGENT 7
1000
5 8 loopback SNASAMAPS05
7 1000
6 8 SYB_JSTASK SNASAMAPS05
7

"Cory Sane" <cory!=sane> wrote in message news:4887ee3e@forums-1-dub...

ThanksButNo

unread,

Jul 25, 2008, 2:16:01 AM7/25/08

to

On Jul 24, 9:06 pm, "fiaola" <fia...@mail.com> wrote:

Off-hand, I'd say you need to edit your SQL.ini file, although I'm not
100% certain, since I usually work in UNIX systems. But it appears to
be the Windows version of the $SYBASE/interfaces file.

> Here is the content of the sysservers in the master.
>
> 1 8 SYB_BACKUP SYB_BACKUP
> 2 1024 SYB_EJB EJBServer
> 10

Your server is looking for a network server entitled "SYB_BACKUP" (the
fourth column shown) to match the "SYB_BACKUP" server (the third
column).

(1 and 8 are columns one and two)

> contents of the SQL.ini
>
> [SERVER05_BS]
> master=NLWNSCK, Server05,5001
> query=NLWNSCK,Server05,5001
>

This APPEARS to be the description for the backup server, assuming
"BS" stands for "Backup Server", not "Bull Stuff."

"SERVER05_BS" is the Sybase name for the host: "Server05" is the
network name that should connect to the host, on port 5001. It can
also be a full DNS name (myserver.mydomain.com) or an IP number.

Think of it as a mapping file. You want to do a backup, so the Sybase
dataserver looks for SYB_BACKUP in the "sysservers" system table. It
finds the Sybase name for the SYB_BACKUP server. Then it looks in
SQL.ini for the Sybase name to find the OS network name and port
number. The backup server process should be running on that host,
listening on that port.

Option 1: Change "SERVER05_BS" to "SYB_BACKUP", which matches what's
in your "sysservers" table.

Option 2: cut-n-paste that entry into a new entry, and call it
"SYB_BACKUP", and give it a new port number (5005, perhaps, instead of
5001). That way, if some other process is looking for SERVER05_BS, it
will still find it.

Although, I'm not sure how Windows starts the backup server. On UNIX,
there is a "RUN" script that specifies the Sybase name. I don't know
how Windows handles that. Find that Windows start-up process, and the
"-S" option (or "/S") specifies the Sybase name. If it's SERVER05_BS,
options 1 and 2 are both out. Unless you want to change the Windows
start-up process also.

Option 3: change the data in the "sysservers" table to match the
SQL.ini file, i.e., set "sysservers.srvnetname" to 'SERVER05_BS'.

The safest way to do that is with:

sp_addserver SYB_BACKUP,null,SERVER05_BS
go

According to the documentation for Sybase 12.5.1, this will add an
entry for SYB_BACKUP, or update it if it's already there. (I've
generally run "sp_dropserver" first, but I guess I don't need to.)

I recommend against updating the sysservers table because it's
dangerous to modify system tables directly. If there's a system stored
procedure, and in this case there is, you should use it.

Take all of this advice with a grain of salt, and be careful. You
might even want to wait for Cory Sane [TeamSybase] to confirm what
I've said before you start.

Luc Van der Veurst

unread,

Jul 25, 2008, 3:16:22 AM7/25/08

to

Your interfaces file has an entry for a SERVER05 server,
Sysservers shows that the name of the server is SNASAMAPS05.
Therefore I assume that the interfaces file isn't the one used by
ASE during startup.

If the same name convention has been used, you should have a
SNASAMAPS05_BS server entry in the correct interfaces file.

Normally dataserver and backupserver can be installed during the
same installation process. In that case, the installation process
adjusts the name of the backupserver in the sysservers table.
In your case, this hasn't been done.

It's easy to correct this, execute :

sp_dropserver SYB_BACKUP
go
sp_addserver SYB_BACKUP, null, SNASAMAPS05_BS
go

If SERVER05_BS is the correct reference to the backupserver,
then you should substitute SNASAMAPS05_BS by SERVER05_BS
in the second command.

Luc.

"fiaola" <fia...@mail.com> wrote in message news:48895148@forums-1-dub...

fiaola

unread,

Jul 25, 2008, 4:13:03 PM7/25/08

to

Thanks Luc, this is the best progress i've made on this task.

Now, i'm getting this error when i try to run the LOAD database command
about the dump file using a wrong sort oder or character set than the ones
used by the dump file. Will search the net for these.

TIA

"Luc Van der Veurst" <dba_...@hotmail.com> wrote in message
news:48897dc6@forums-1-dub...

Sherlock, Kevin

unread,

Jul 25, 2008, 11:01:41 PM7/25/08

to

Just recreate your loading ASE server to use the same character set/sort
order.

"fiaola" <fia...@mail.com> wrote in message news:488a33cf@forums-1-dub...