SQL Server 2000. I use Veritas BackupExec to backup files on my system. I
just added an agent that allows backing up SQL databases. My question is
independent of which backup saoftware one uses. Here is my question:
When backing up an instance of SQL Server (such as (LOCAL)), should I backup
only my databases or backup my databases and the system databases. That is,
should I backup my databases and master, model, msdb?
Thanks for any help. God bless.

Signature
Dr. Doug Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.org
Jens - 31 Jan 2006 15:55 GMT
Look in the BOL why these databases are important, just to give a small
hints of the features of the database:
-master (like the names tells its the mater which contains every
information like server users etc. It can be rebuilöding once the
system is crashed, but restoring this is a much easier job to do)
-msdb (stores all your agent job)
-model (is used a a template for other databases when they are created,
if you defined any templates in your company they can be pulled out of
this one, if you don´t you don´t have to bother)
HTH, Jens Suessmeyer.
Chaplain Doug - 31 Jan 2006 16:40 GMT
Thanks Jens. The answer I derived from you comments is "Back them all up!"
Thanks and God bless.

Signature
Dr. Doug Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.org
> Look in the BOL why these databases are important, just to give a small
> hints of the features of the database:
[quoted text clipped - 8 lines]
>
> HTH, Jens Suessmeyer.