Gnanasekaran Kuppusamy
Reputation
Next privilege 15 Rep.
Flag posts
Badges
2
Newest
 Editor
Impact
~931 people reached

  • 0 posts edited
  • 0 helpful flags
  • 0 votes cast
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