• First, before I do anything on a new server I stand up a pre-determined utility database for DBA related activities. Maintenance jobs that I run but not limiting to are:

    Clearing out aged backups

    Creating backups for new databases that get dropped onto my server ( in my case all DB's are mission critical )

    Cycle SQL Server Error Logs

    Index Defrag

    Smart Re-Indexing

    Alerting on Extended Blocking

    Again, these are my main chunks for maintenance but definitely not limiting what I have listed. You could have more, 50GB is not really that big. Should be able to get a good grasp on it.

    Thanks,

    Chris