Solved

Creating a backup server

Posted on 2006-11-27
2
1,169 Views
Last Modified: 2010-05-18
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
0
Comment
Question by:KnightFire
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 19

Accepted Solution

by:
grant300 earned 500 total points
ID: 18020666
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
 
LVL 3

Author Comment

by:KnightFire
ID: 18021172
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

Featured Post

Enroll in June's Course of the Month

June’s Course of the Month is now available! Experts Exchange’s Premium Members, Team Accounts, and Qualified Experts have access to a complimentary course each month as part of their membership—an extra way to sharpen your skills and increase training.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After seeing many questions for JRNL_WRAP_ERROR for replication failure, I thought it would be useful to write this article.
If you are IT support and need to work after hours to resolve customer issues then here are a few tips on how to handle after hours support
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question