Solved

dump database issue

Posted on 2001-07-02
4
1,717 Views
Last Modified: 2010-10-05
Hi,

I've got the following issue while a dump database :

[artel-dev] arbor [18] % isql -Usa -Psacom9 -SDEV9_DS
1> dump database ARBOR_DB to "/home/arbor/sauvegarde/dev9/dump20010702_cust.dmp"
2> go
Msg 7205, Level 17, State 2:
Server 'DEV9_DS', Line 1:
Can't open a connection to site 'SYB_BACKUP'.  See the error log file in the SQL
Server boot directory.
Msg 7205, Level 18, State 3:
Server 'DEV9_DS', Line 1:
Can't open a connection to site 'SYB_BACKUP'.  See the error log file in the SQL
Server boot directory.


Any idea ?

Thanks in advance
0
Comment
Question by:Richard Coffre
  • 2
4 Comments
 
LVL 3

Expert Comment

by:mathavra
ID: 6246264
Backup server process should be up and running for doing backups in Sybase. Can you check whether the backup server is running?.

If not, use the startserver command to start the backup server.
0
 
LVL 4

Accepted Solution

by:
Otetelisanu earned 50 total points
ID: 6247446
make

1. Look ps -ef|grep RUN if you BACKSERVER is up

if is up

2. sp_helpserver and look your
SYS_BACKUP BACKSERVER

and
look file interfaces
(with dsedit)
and look BACKSERVER if is there



0
 
LVL 1

Author Comment

by:Richard Coffre
ID: 6254502
Thank for your answer which waw the most complete.
0
 
LVL 1

Author Comment

by:Richard Coffre
ID: 6254505
Thanks for your answer which was the most complete.
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How do we check sybase license in ASE 1 2,836
Sybase IQ how to log personalized Users? 1 203
SQL Query Help! 11 121
Best cheaper way to convert to not editable document 6 43
When we purchase storage, we typically are advertised storage of 500GB, 1TB, 2TB and so on. However, when you actually install it into your computer, your 500GB HDD will actually show up as 465GB. Why? It has to do with the way people and computers…
Data breaches are on the rise, and companies are preparing by boosting their cybersecurity budgets. According to the Cybersecurity Market Report (http://www.cybersecurityventures.com/cybersecurity-market-report), worldwide spending on cybersecurity …
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

808 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