Solved

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

Posted on 2011-09-23
3
246 Views
Last Modified: 2012-06-21
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?
0
Comment
Question by:gtrapp
  • 2
3 Comments
 
LVL 51

Accepted Solution

by:
Mark Wills earned 400 total points
ID: 36592089
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
 
LVL 14

Assisted Solution

by:Daniel_PL
Daniel_PL earned 100 total points
ID: 36592094
0
 
LVL 14

Expert Comment

by:Daniel_PL
ID: 36592096
Sorry Mark, while answering your answer wasn't there.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Generate Scripts of Schema/Data with "WHERE" clause 6 72
Help  needed 3 35
How do I subtract date and time within a same column in SQL 4 41
PROPERCASE SCRIPT IN SQL 3 16
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question