Cannot Restore from Backup File to Sybase -


we have old sybase server. our database in acting up. need restore backup database file our backup sybase server. when try that, keep getting error message:

msg 7205, level 17, state 2: line 1: can't open connection site 'syb_backup'. see error log file in sql server boot directory.

that how restore database backup: 1. use rcp copy dump file spare server primary server. , name copy "frombkup_mydb.dump". 2. drop old database primary server, , re-create empty one. 3. use following command load database backup dump file:

load database mydb "/export/home/syb11.dump/frombkup_mydb.dump"

unfortunately don't know error log file is. not familiar sco unix , sybase.

does know why restore doesn't work?

please help. thanks.

jay chan

it's backup server not running.

the sap/sybase ase database process requires backup server running database backups or restores.

to find database processes running can use showserver command located in:

$sybase/$sybase_ase/install/showserver 

if backup server not running (likely), in ./install/ directory, file named run_syb_backup

you can start server issuing command (from ./install/ directory)

startserver -f run_syb_backup 

this should start backup server, , allow restore database.


Comments

Popular posts from this blog

javascript - gulp-nodemon - nodejs restart after file change - Error: listen EADDRINUSE events.js:85 -

Fatal Python error: Py_Initialize: unable to load the file system codec. ImportError: No module named 'encodings' -

javascript - oscilloscope of speaker input stops rendering after a few seconds -