Sql Anywhere 定期数据备份解决思路

Sql Anywhere 定期数据备份


  CREATE EVENT NightlyBackup 
  SCHEDULE 
  START TIME '23:00' EVERY 24 HOURS 
  HANDLER 
  BEGIN 
  DECLARE dest LONG VARCHAR; 
  DECLARE day_name CHAR(20); 
   
  SET day_name = DATENAME( WEEKDAY, CURRENT DATE ); 
  SET dest = 'd:\\backups\\' || day_name; 
  BACKUP DATABASE DIRECTORY dest 
  TRANSACTION LOG RENAME; 
  END;

------解决方案--------------------
挺好,我原来都用windows的任务计划
------解决方案--------------------