Home > Articles > Data > SQL Server

  • Print
  • + Share This

Which Databases Should You Back Up?

This advice might sound obvious, but you should back up all your user-defined databases. If creating the database and putting it on a server are important enough, backing it up is also important. What about system databases? You should back up master and MSDB. Having a backup of the model database might be useful, but you don't need to back up tempdb. If you are using replication, you should also back up your distribution database regularly. I recommend that you treat it like any other frequently modified user database.

  • + Share This
  • 🔖 Save To Your Account

Related Resources

There are currently no related titles. Please check back later.