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?
That won't work. Your best bet is probably to use the bcp utility, to export the data from each table.