Do I've to backup system databases?

[Guest_imported]

Do I've to backup [master] and [msdb] to be safety in case of the server is corrupted or any of the user databases is damaged?.

Is it enough only to backing up all user databases or I've to backup system databases also?

If yes, what kind of bakcup recommended to use with [master] and [msdb](Full,Differential or Transaction) ?weekly,monthly or daily ?

Any help would be much appreciated.

 

[tlbroadbent]

Backups of the master and msdb system databases are critical. They contain all the information about your SQL Server configuration, security, backup history, jobs, DTS packages, and more. This is data you cannot afford to lose.

We do a full backup daily. Others may do more frequent backups depending on needs. It is important to develop a backup and recovery strategy based on the needs of your organization, the frequency of updates, the importance of the data, etc. The following resources will help you develop a backup and recovery strategy.

Read Backing Up and Restoring Databases in SQL BOL.

http://msdn.microsoft.com/library/en-us/adminsql/ad_bkprst_9zcj.asp

http://msdn.microsoft.com/library/en-us/howtosql/ht_7_backpt_15ro.asp

Backing Up and Restoring System Databases

http://msdn.microsoft.com/library/en-us/adminsql/ad_bkprst_7u0j.asp

Neil Boyle has created the online "Impetus DBA Handbook." It contains sections covering various aspects of backing up SQL Server databases.

http://www.impetus-sql.co.uk/

Check out these articles by other authors and SQL Server users.

Creating a "Complete" Backup Solution

http://gethelp.devx.com/techtips/thesqlpro/10min/10min0101/10min0101.asp

Backup strategies

http://www.sqlmag.com/Articles/Index.cfm?ArticleID=9629

Restoring databases

http://www.sqlmag.com/Articles/Index.cfm?ArticleID=9808

Speed database recovery with differential backups

http://www.swynk.com/friends/boyle/dbbackup.asp

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[sguslan]

Hi Mona ..

Normally, the Master database is small. You can just back it up to disk on daily basis and move the backup files through network to another server or to tape...

Good luck

Salim