 |
 |
 |
 |
|
|
|
|
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
Hint Ref: 020706290005
Hint Date: 29/06/2007
Hint Details:
EFFECTED VERSION: Sybase 8
DETAILS:
Modify the follow SQL to correct the backup time and target directory. Then run in an SQL window:
CREATE EVENT SMDailyBackup
SCHEDULE daily_backup
START TIME '7:00AM' EVERY 24 HOURS
HANDLER
BEGIN
BACKUP DATABASE
DIRECTORY 'L:\\dbbackup\\NickyDemo'
TRANSACTION LOG TRUNCATE
END
(L:\SM4WIN\SQL_Events\daily backup.txt)
|
|
|