Back up database to a network drive in sybase central
Posted on 2004-09-03
I am trying to back up my database ( I am using sybase central) using ISQL analyzer , I am not able to back up to a network drive, I have no problem if i back up to the local drive. It is showing this error
ASA Error-697:Error during back up : could not create directory R:\Backup\Friday--No such directory or permission denied.
I am trying to do this from the dba account with full permisiions. Can you help me ?
the event handler has this code
declare day_of_week varchar(20);
declare backup_stmt long varchar;
set backup_stmt='BACKUP DATABASE DIRECTORY ' || '''R:\\Backup\\' || day_of_week || ''' ';
if day_of_week <> 'SATURDAY' then
set backup_stmt=backup_stmt || 'TRANSACTION LOG ONLY'
set backup_stmt=backup_stmt || 'TRANSACTION LOG TRUNCATE'
execute immediate backup_stmt;
insert into tblEventLog(EVLOG_szOperator,EVLOG_szOption,EVLOG_szMessage) values('System','Backup','Backup Completed')