Hi,
am using DBACOCKPIT SQL script to schedule daily backup for our Sybase database, i want to keep 7 files as retention so i need the backup file name to contain today day name for example
PRD_Backup_Saturday.dump
PRD_Backup_Sunday.dump
PRD_Backup_Monday.dump
.....
command should be something like this:
dump database DMR to "D:\SAP_DB_BACKUP\PRD\PRD_Backup_" + getdate(day) + ".dump" with compression=101
how can i achieve that.
Thanks