Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am using SQL Server 2008 R2. I am trying to create a maintenance plan which backs up multiple databases into one single folder for a day.

For ex. I need to backup db1, db2, db3 and dump all these 3 .bak files into a single folder with a date.

Is this possible?

Any help would be really help. Thanks in advance.

share|improve this question
    
Do I understand it clearly that you want all database backups to be in one folder per day? Eg: 20121203 -> all backups from 2012.12.03, 20121204 -||-||- same for 2012.12.04? –  Marian Dec 3 '12 at 12:38
    
Let me try to explain bit clearly. for ex. i want a folder for a day something called "20121203" inside that i need all the backups like db1_20121203.bak, db2_20121203.bak, db3_20121203.bak then for the next day there should be a new folder called "20121204" inside that i need all the backups like db1_20121204.bak, db2_20121204.bak, db3_20121204.bak. –  Gnanasekaran Kuppusamy Dec 3 '12 at 13:43
add comment

migrated from stackoverflow.com Dec 3 '12 at 9:46

This question came from our site for professional and enthusiast programmers.

1 Answer

Yes it is possible Use the Maintenance plan wizard its pretty easy to use. Set your schedule type to recurring and frequency to daily on the "new job schedule form" when you get to the "Define Back Up Database Task" form select the databases you wanna backup and select "create a backup file for every database " then set path of the folder you want to save to.

hope that helps

share|improve this answer
    
But this is creating folder for each database. But what am asking is all 3 .bak files in a single folder for the day. Let me try to elaborate bit more. I have scheduled daily backup for 3 databases. When I see the backup file path, am getting 3 .bak files in it. what i would like to do is all these 3 backup files in a single folder. –  Gnanasekaran Kuppusamy Dec 3 '12 at 13:39
    
for ex. i want a folder for a day something called "20121203" inside that i need all the backups like db1_20121203.bak, db2_20121203.bak, db3_20121203.bak then for the next day there should be a new folder called "20121204" inside that i need all the backups like db1_20121204.bak, db2_20121204.bak, db3_20121204.bak. –  Gnanasekaran Kuppusamy Dec 3 '12 at 13:47
    
Then you are going to have to create separate maintenance plans for each database and direct the backups to the individual folders –  Yugz Dec 3 '12 at 14:49
    
-1 since this does not answer the question. –  Max Vernon Dec 3 '12 at 15:40
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.