Gnanasekaran Kuppusamy

less info
11 reputation
2
bio website
location Bangalore, India
age 30
visits member for 1 year, 8 months
seen Dec 6 '12 at 10:21

Dec
6
awarded  Editor
Dec
6
revised SQL Server Maintenance Plan multiple database backups in a single folder
added 53 characters in body
Dec
3
comment SQL Server Maintenance Plan multiple database backups in a single folder
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.
Dec
3
comment SQL Server Maintenance Plan multiple database backups in a single folder
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.
Dec
3
comment SQL Server Maintenance Plan multiple database backups in a single folder
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.
Dec
3
awarded  Student
Dec
3
asked SQL Server Maintenance Plan multiple database backups in a single folder