?
Solved

Creating a backup server

Posted on 2006-11-27
2
Medium Priority
?
1,172 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 2000 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

Get MySQL database support online, now!

At Percona’s web store you can order your MySQL database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card.

Question has a verified solution.

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

In the absence of a fully-fledged GPO Management product like AGPM, the script in this article will provide you with a simple way to watch the domain (or a select OU) for GPOs changes and automatically take backups when policies are added, removed o…
This article will show how Aten was able to supply easy management and control for Artear's video walls and wide range display configurations of their newsroom.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

762 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