|
babloo
Starting Member
USA
31 Posts |
 Posted - 01/31/2013 : 08:56:08
|
Hi, I am sorry if this is not the right place to post this question.
I currently have a maintenance plan that will first take the full backup of databases and then remove backup files. The problem is, the system first takes the backup and gets to a point where the drive gets full and fails the job, it does'nt get to a point to delete backup files.
I have an option to move Delete files first then take backup but that is not the right practice, that leaves me in a risk mode.
Is there a way you could help me with a script that will take full backup individually and remove old backup file for that database then take the next backup and delete back. So it can balance the storage?.. I only want active databases to be in this category.
Thanks
Babloo |
|
Maintenance plan backup job
