February 9, 2004 at 1:19 am
Hi All,
Our SQL Server 2000 Enterprise Server contains 22 databases.
I need to set a backup schedule for all the databases daily.
The desitnation folder for the backups depends on the current date.
If the date is 09Feb2004 then the folder name will be \09Feb2004 and all the backups should be taken in that folder. So this will be daily routine schedule.
So, which is the best strategy to implement this.
Setting a job schedule will not satisfy this.
Please help.
Regards,
Jag
February 9, 2004 at 1:26 am
use backup media.
backup the db using that media (so you always backup to the same physical directory)
in the last step of your backup-job, you can move the backupfiles to the directory you want to, depending on the day of the week with plain DOS.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 9, 2004 at 1:41 am
but I want to automate this instead of creating the folders manually. Will I able to write any scripts?
February 9, 2004 at 1:50 am
you can use dos variables to create your directories (one a day) and the move the bak-files to it.
I didn't mention it earlier, but you can have sqlserver managing your backupfiles. i.e. sqlserver can delete files older than, ...
Check "maintenance plan" in BOL or in EM.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 9, 2004 at 1:53 am
thanks, i will try
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply