Post reply

Backup All User Databases

  • June 13, 2015 at 12:32 pm

    #398587

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

    Greg Roberts

  • June 15, 2015 at 7:13 am

    #1805439

    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.

  • June 15, 2015 at 1:36 pm

    #1805563

    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

  • June 25, 2015 at 8:10 am

    #1808077

    Thanks for the script.

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

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