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
Operators
Server Objects, like linked servers

If I backup the Master and msdb databases, will these things be backed up?
gtrappAsked:
Who is Participating?
 
Mark WillsConnect With a Mentor Topic 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.



0
 
Daniel_PLDB Expert/ArchitectCommented:
Sorry Mark, while answering your answer wasn't there.
0
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.

All Courses

From novice to tech pro — start learning today.