Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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 stackoverflow.com Nov 15 '11 at 23:48

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

2 Answers 2

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

 
discard

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