system database backups missing

Please elaborate on the risks if you find the sql dba has not been backing up the default sql databases (ie msdb master model etc). When would you ever need to restore data from those databases.. what is the risk in not backing them up if any.
LVL 3
pma111Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

pcelbaCommented:
If you don't store your own information to these system databases intentionally then you don't need their backup. Of course, if the SQL Server crashes then you have to make a fresh install and restore your production database only.

The backup copy of your production data is possible to restore on any SQL Server instance which you have available. The data version must be compatible to the SQL Server instance. The backward compatibility is good for MS SQL Server obviously.
0
Steve WalesSenior Database AdministratorCommented:
I respectfully disagree with pcelba.

You might be able to get by without model (which is really just the template used for creating a new database).

Master contains all the instance logins and system configuration data and also records the existence of all other databases in the instance.

Master contains all of the system level information for the instance.

If you have 100 databases in your instance, losing master is going to cause you no end of pain.

Msdb is used by SQL Server agent.  If you have dozens of Agent jobs, recreating all of them from scratch is also going to be a major pain.

If you don't have them backed up, make that happen immediately.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
pma111Author Commented:
Steve should it be a daily backup for those databases in your opinion as a dba
0
Steve WalesSenior Database AdministratorCommented:
They shouldn't be that large ... I do mine daily.

The Doco says to back up as often as necessary to protect the data sufficiently for your business needs.

Refer http://msdn.microsoft.com/en-us/library/ms190190.aspx

Daily should be more than adequate.  If you find a day where you have a lot of core system level changes going on (lots of new users or databases or similar) then maybe an ad hoc backup after the changes are made just to be safe.

Remember, backups are an insurance policy.  You never need them until you NEED them.  I have been a homeowner for 25 years and have never made a claim on my homeowner's insurance.

However, I have never NOT been insured for the value of my house,

Treat your databases the same way.  Data loss can ruin a company.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

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.