CODEWITHSUNDEEP
sap-asedatabase-backups
lolcode
lolcode

Reputation: 285

How to backup a remote Sybase database to a local file?

I am connected remotely to a Sybase server that is on a UNIX machine. I am connected via isql GUI on a windows client. I do not have access to the UNIX server's interfaces file so I don't think I can set up my machine as a remote backup server. 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? The database is about 9GB. I suppose I should run this in the off hours if possible?

Upvotes: 1

Views: 2392

Answers (2)

mypoc
mypoc

Reputation: 11

Your windows machine should also:

1) have Sybase ASE AND Backup Service installed

2) define on both interfaces and sql.ini files in both instances.

Your command will then be:

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

for more info: http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc31644.1600/doc/html/san1371158725683.html

Upvotes: 1

Mike Gardner
Mike Gardner

Reputation: 6651

That won't work. Your best bet is probably to use the bcp utility, to export the data from each table.

Upvotes: 1

Related Questions