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
Post a Comment