Solved

Creating a backup server

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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

The business world is becoming increasingly integrated with tech. It’s not just for a select few anymore — but what about if you have a small business? It may be easier than you think to integrate technology into your small business, and it’s likely…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

860 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