Creating a backup server

Using: Sybase 12.5 on Solaris.

I am trying to load a database from a compressed file and get the following error.
Msg 7205, Level 17, State2:
Server 'myserver', Line 1:
Can't open a connection to site 'SYB_BACKUP'. See the error log file in the SQL Server boot directory.

When I created my server I didn't create a backup server for it, as it is only for development, however it looks like that was a mistake. What is the easiest way to create a backup server and configure it to get the database load to work?
Preferably I would like command line solutions as it is not easy to get X windows access to the box.

KF
LVL 3
KnightFireAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
grant300Connect With a Mentor Commented:
Unlike a data server, configuring a backup server is pretty straight forward.

You really only need three things to make it run:
1) the interfaces file entries,
2) the syservers entry, and
3) the startup script for the backup server

The interfaces file entries are very straight forward, just assign a name for the backup server and give it a unique port number.

The sysservers entry is also easy.  Use sp_addserver with Servername of SYB_BACKUP, a network server name of whatever you gave it in the interfaces file, and a class of ASEnterprise.

You may be able to poke around and find the startup script for the backup server or you can pirate one from one of your production servers.

Go take a look at one of the other systems that has it and you can see the end-to-end layout.

BTW, you know that the database definition interms of size and order of the individual extents must be the same as the system you got the dump from or it won't load properly.  All of the constraints and limitations are covered in the System Admin guide.

Best of luck,
Bill
0
 
KnightFireAuthor Commented:
Hi,
Thanks for that,
I  had the correct sizes etc, so it was just the backup server I needed to get configured. Following your hints I got it working and everything is now loaded.

Cheers,

KF
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.