Skip to Content
0
Jun 20, 2022 at 02:04 PM

how to add today name for Sybase ASE DB backup filename

112 Views

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