Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I would like to know to how to take backup of system databases? and is there any difference between taking backup of user databases and system database? and how to restore? I need T-SQL command?

share|improve this question

migrated from Nov 15 '11 at 23:48

This question came from our site for professional and enthusiast programmers.

The commands are the same, that's true, but system DBs do need special consideration both for backup and for restore. The topic is discussed at length in the Considerations for Backing Up and Restoring System Databases chapter in BOL. This has also 4 sub-chapters about backing up and restoring masteron one hand, and model and msdb on the other hand. Read the documentation first, then come back if you still have more questions.

share|improve this answer

Backing up a system database is basically the same than backing up a non-system database, as marc_s already pointed out in his comment.

One difference is that the system databases are always in Simple Recovery Model, so it's not possible to do transaction log backups.

share|improve this answer
This is patently untrue. – adaptr Jan 28 '13 at 15:15

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.