Wednesday, March 21, 2012

Database Backup

Hi,

Currently i schedule my SQL sever agent to do database backup once in a few days with the default backup file name to ABC. Hence everytime, it will overwrite the previous file. Is there a way for me to auto append date time at the back of my default file name? Eg will be ABC_DD_MM_YYYY
Thanks!

Regards,
weihann.If you right click your database name, choose all tasks -backup database, you can find what you want.

No comments:

Post a Comment