If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back  dBforums > Database Server Software > Sybase > Newb question about dump

LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Registered User
Join Date: Sep 2012
Posts: 3
Newb question about dump

I have searched Google and these forums but I'm still not clear if I can just use the dump command or if I have to set up backup servers in the interfaces file as shown here: http://www.sybase.ca/detail?id=20334

I am connected remotely to a sybase server that is on a UNIX machine. I do not have access to it's interfaces file. I am connected via Isql GUI on a windows client. Can I use the following command to get a backup on my Windows machine?

dump database mydb to "C:\mydb.dmp"

Also what is the performance penalty? I suppose I should run this in the off hours if possible?

Last edited by britebyte; 01-03-13 at 12:04. Reason: Grammar
Reply With Quote
  #2 (permalink)  
Registered User
Join Date: Mar 2008
Posts: 96
As u are connected from windows m/c (which is client here) to the UNIX m/c (which is a server).
So from client whatever command u fire executes on server and will generate the o/p on server itself.

So in your case u r looging in from a client to a server, and trying to take the backup on server and want the files to be created on client ..... which is highly impossible.

the way around is take the database dump on server and ftp it from Unix m/c (server) to your local m/c.

But i am wondering why do u require backup on your local m/c, as the database must be there on server only.
Reply With Quote
  #3 (permalink)  
Registered User
Join Date: Jan 2004
Location: The Hague/Utrecht, NL
Posts: 504
To dump a database you need a functioning Sybase server and a functioning Backupserver. It is not nessecary to have the backupserver detail in the interfaces file on your client, because you connect to the Sybase server when issuing a dump database, not to the backup server.

The path you use i the dump database command should be an existing path on the database server, not on the client.
I'm not crazy, I'm an aeroplane!
Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On