We have a very old SUN SPARC workstation running Solaris 2.4 (SunOS v5.4).
It's being used to run Sybase. The database in it is acting up. We have a spare SUN workstation with nearly identical specs and are trying to restore the backup database from workstation to the other.
When we try to do this, we get the following error message:
Msg 7205, Level 17, State 2:
Can't open a connection to site 'SYB_BACKUP'. See the error log file in the SQL Server boot directory.
Unfortunately I don't know where the error log file is. I am not familiar with Solaris.
That is how we tried to restore the database backup:
1. Use RCP to copy the dump file from the spare server to the primary server. And name the copy "frombkup_mydb.dump".
2. Drop the old database from the primary server, and re-create an empty one.
3. Then use the following command to load the database from the backup dump file:
load database mydb from "/export/home/syb11.dump/frombkup_mydb.dump"
Does anyone know why the restore doesn't work?
Please help if possible.