timbeullens
IS-IT--Management
Hi, since I'm more a Hardware-IT guy, I have quistions about the correct programming of a good Backup plan for our SQL Server.
The idea is that I Backup our Databases (5 in total under a single server) every day.
The backups will be stored on a second disc, which is taped every day.
What I want to do is to create a backup of all databases every day, and keep those files for a week.
For example, on monday i create 5 backups (1/database) with suffix Monday that will be overwrited the next monday.
And this for every week day.
How can I do this best?
Do I need to make 7 jobs, one for each day and schedul them on the right day?
Or can I write a script that will add the date or day of the week automatically, and then overwrites the file of the same weekday from the week before?
I'm a complete dummy in SQL so anny help is verry welcome!!
Thanx in advanced!
Tim
tim@cvwarehouse.com
The idea is that I Backup our Databases (5 in total under a single server) every day.
The backups will be stored on a second disc, which is taped every day.
What I want to do is to create a backup of all databases every day, and keep those files for a week.
For example, on monday i create 5 backups (1/database) with suffix Monday that will be overwrited the next monday.
And this for every week day.
How can I do this best?
Do I need to make 7 jobs, one for each day and schedul them on the right day?
Or can I write a script that will add the date or day of the week automatically, and then overwrites the file of the same weekday from the week before?
I'm a complete dummy in SQL so anny help is verry welcome!!
Thanx in advanced!
Tim
tim@cvwarehouse.com
