Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
stan9
Starting Member
3 Posts |
 Posted - 2004-05-09 : 01:28:02
|
| I have 20 databases and i need to backup them daily. Basically, i generate 7 jobs for each databases (mon - sun) so that it backup to folder mon, tue, etc... For future, the database will be increase, how can i solve this problem? |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2004-05-11 : 10:06:57
|
| Why 7 jobs?One job should be enough. One job will take the backup in a perticular folder daily. Then may be you can write a batch file and schedule it to copy to different folders (mon, tue, wed..) or this can be achieved in the job itself..------------------------I think, therefore I am |
 |
|
|
|
|
|
backup database