Issue Description
Can not backup database ,the prompt wrong info as follow:
Msg 7205, Level 17, State 2:
Server 'mav1_server0', Line 1:
Can't open a connection to site 'SYB_BACKUP'. See the error log file in the SQL
No other query entry found for the remote server SYB_BACKUP - site SYB_BACKUP.
Handling Process
(1)check the database backup process running normally
(2)check the interface file config correctly
(3)excute sp_helpserver or (select * from sysservers) to check:
select * from sysservers
go
srvid srvstatus srvname
srvnetname srvclass
srvsecmech
------ --------- ------------------------------
-------------------------------- --------
------------------------------
0 8 N2000DBServer
mav1_server0 0
NULL
1 8 SYB_BACKUP
SYB_BACKUP NULL
NULL
Refer to the check result :
In SYB_BACKUP row:srvnetname is SYB_BACKUP which is not as same as N2000DBServer_back in interface file, this is wrong.
Please take notice: srvname is the server name in sybase system servert table.(such as:N2000DBServer, the backup server is SYB_BACKUP),
srvnetname is the interface files name of Sybase , so it is same as the name in interface file in Sybase directory.
(4) modify the srvnetname in sysservers system table , so should modify the name to make sure that the srvnetname is same as name in the interface file.
The modify as follow:
1>sp_configure 'allow updates to system tables',1
2>go
1>update sysservers set srvnetname = 'N2000DBServer_back' where srvname = 'SYB_BACKUP'
2>go
Root Cause
From the wrong prompt , it shows that not find the SYB_BACKUP when back up.