database backup question

I have a maintanence plan on all of my SQL servers, both SQl 2000 and SQL
2005. My question is, do I need to backup the Master. MDB, Model and tempdb,
databases or can I exclude them from my plan?
They are system databases. So you should backup them when major changes are
made on the SQL Server Instance.
For example you should backup your "master" database when you create new
logins, linked servers etc. You should backup your "msdb" when you create
new jobs... And "model" if you made changes on the model database which is
the kinda template database...
You do not need to backup tempdb as it will be deleted and recreated
everytime your SQL Server service starts...
I encourage you to take a look at the following link to learn more about
Backing Up and Restoring System Databases:
http://msdn2.microsoft.com/en-us/library/ms190190.aspx
P.S.
You do not need to backup system databases regularly as your user databases
and do not include these system databases in your regular backup maintanence
plan. You don't need this...
Ekrem nsoy
"Mike" <Iseeyoulooking@.move.com> wrote in message
news:uYQV%233YPIHA.5400@.TK2MSFTNGP04.phx.gbl...
>I have a maintanence plan on all of my SQL servers, both SQl 2000 and SQL
>2005. My question is, do I need to backup the Master. MDB, Model and
>tempdb, databases or can I exclude them from my plan?
>
|||On Dec 13, 3:42 pm, "Mike" <Iseeyoulook...@.move.com> wrote:
> I have a maintanence plan on all of my SQL servers, both SQl 2000 and SQL
> 2005. My question is, do I need to backup the Master. MDB, Model and tempdb,
> databases or can I exclude them from my plan?
You can exclude the tempdb because there is no way to restore it
anyway. The tempdb just as its name implies is temporary and is being
created by the server each time that the service starts.
Model database will only be modified if you modify it. This
database is used as a model for the server to create databases. If
you want each new database to have some objects in it, then you create
it in Model database and then each time that you'll create a new
database, you'll have those objects in the new database. If you
create objects in the model database, then you can backup the model
database. In other cases I don't see a reason to do it.
Master and MSDB store important data about logins, server's
configuration, databases' location and configuration (master) and jobs
and DTS packages (MSDB). Those databases should be backed up on a
regular basis.
Adi
sql