Backup All User Databases

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

    Greg Roberts

  • 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.

  • 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

  • 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