DB Maintenance Backup Job not deleting old backups

  • Maverick (7/12/2006)


    Are you taking the backup of all the databases through one maintenance plan only. If the answer is yes then there must a backup which would be failing and no further backups or deletion of old backup after that would be happenning.
    So you need to check the server logs to see if any backup is failing or not.
    It is advisable to create separate maintenance plans for different dbs.

    Maverick, we are a small shop and some of our database servers (20 plus) host up to 80 databases. Having to create a separate maintenance plan for each databases seems impractical.

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply