• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 255
  • Last Modified:

What do I backup when I back up the Master and msdb database?

I like to back up the following:

Maintenance Plans
Logins, at the SQL Server level
Memory and Connections settings
Database Mail settings, like profiles and accounts
Server Objects, like linked servers

If I backup the Master and msdb databases, will these things be backed up?
  • 2
2 Solutions
Mark WillsTopic AdvisorCommented:
Yes.  Master and MSDB are the two most important.

There are others like Model and Resources but resources is treated more like a binary file and physically backed up (not SQL Server backup), and model is often not really used / changed unless you specifically have used it and so doesnt warrant regular backup (well some places never do).

Have a read of : http://msdn.microsoft.com/en-us/library/ms190190.aspx

It can be *interesting* restoring Master and you should really follow the links for "special considerations". You might prefer to script permissions and so on so they can be reapplied more easily.

Daniel_PLDB Expert/ArchitectCommented:
Sorry Mark, while answering your answer wasn't there.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now