Backup All User Databases

  • Greg Roberts-134214

    SSCommitted

    Points: 1686

    Comments posted to this topic are about the item Backup All User Databases


    Greg Roberts

  • anna.lunyova

    SSC Rookie

    Points: 35

    Thanks for this - just a note: why are we backing up only user databases? System databases are essential for the server recovery and must be backed up daily as well.

  • Greg Roberts-134214

    SSCommitted

    Points: 1686

    You are correct, system databases are every bit as important. But in my environment they do not require as aggressive a backup schedule. So i basically run 2 versions. ! for User databases and a second for System database.

    If you feel very adventurous you could create a table that stores the databases on your system and add meta data to determine when and what type of backup to run. But then the table has to be maintained. So we turn the wheel and start over again. 🙂

    Please feel free to use this as a jumping off point for your own backup strategies.


    Greg Roberts

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Thanks for the script.

Viewing 4 posts - 1 through 4 (of 4 total)

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