p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   SQL Server 2000 (http://p2p.wrox.com/forumdisplay.php?f=20)
-   -   Backup (newbie question) (http://p2p.wrox.com/showthread.php?t=506)

Graham June 12th, 2003 12:13 PM

Backup (newbie question)
 
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.


All times are GMT -4. The time now is 08:08 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.