Backup (newbie question)

Graham · June 12th, 2003, 12:13 PM

Hi

I have an SQL database that I need to backup every evening but to different filenames ie Monday.BAK, Tuesday.BAK etc

Does this mean I need to schedule seven backups each to run weekly and specify the backup name accordingly?

Regards
Graham

ram2098 · June 12th, 2003, 03:54 PM

You can write a small procedure to generate the back device name dynamically based on the week and schedule the procedure to run every evening.

Graham · June 13th, 2003, 03:39 AM

Hi

Don't know how to do that, probably a little too advanced for me!
Could you point me to any resources that explain or let me have a little more info?

Regards
Graham

Quote:

quote:Originally posted by ram2098
You can write a small procedure to generate the back device name dynamically based on the week and schedule the procedure to run every evening.