Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / General / Setup / January 2006

Tip: Looking for answers? Try searching our database.

Backing up SQL Databases

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Chaplain Doug - 31 Jan 2006 15:25 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.