Add Date variable to DB backup to file

[andre_jansevanrensburg]

Hi All

Running AIX 5.3 ECC6, and Maxdb 7.8

I use DBA Calender to schedule my backups

When creating a backup template for backup to file is there a way that i can add a date variable.

So that in the filename that is written to disk the date is included in the filename

Because when i backup this flat file to tape using TSM i want the date of the backup to show.

Regards

[Former Member]

Hi,

Getting a date variable automatically in templates would be difficult. You can think of creating templates day wise ( Mon, Tue,...Sun). Atleast you can have a track which day backup is moved to TSM.

Regards,

Deepak Kori

[andre_jansevanrensburg]

Hi

Yes that is what i have done

Just wanted to add the date too

Thanks for your response

[Former Member]

Hi,

As per the link below there does not seem any option of getting date variable. Also hardcoding each date would not be a good solution.

http://maxdb.sap.com/doc/7_7/c3/64bc3e75b54f0381bf558a42d5d4f5/content.htm

Above link shows standard options available for backup template creations.

Hope this helps.

Regards,

Deepak Kori

[Mark_von_Wilmowsky]

According to the MaxDB documentation it's possible to use the following placeholder within the backup's filename:

• #YYYY: year

• #MM: month

• #DD: day

• #hh: hour

• #mm: minute

• #ss: second

Example

DEMODB_DATA_#YYYY-#MM-#DD

Source at help.sap.com