Solved

Creating a backup server

Posted on 2006-11-27
2
1,134 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
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Query 2 325
Time optimization for insert/update in ultralite. 3 126
Loading very large range partitioned tables in Sybase/ASE 15.7 5 146
Need help with SYBASE syntax 5 70
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
In 2017, ransomware will become so virulent and widespread that if you aren’t a victim yourself, you will know someone who is.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This is a video that shows how the OnPage alerts system integrates into ConnectWise, how a trigger is set, how a page is sent via the trigger, and how the SENT, DELIVERED, READ & REPLIED receipts get entered into the internal tab of the ConnectWise …

930 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now