Backup types for System Databases || SQL Server
Few days before me and my friend were discussing about SQL related things, while discussion he asked me question like how many types of backup we can take for system databases. That question put me in thinking. Because, I never thought much about different types of system database backups and I believe many of us not so bother about knowing the same. However, it is quite interesting to know how many types of backups we can perform on system databases. The direct answer for this question is as below. 1. Master: Only can take full Backup 2. Model: Full, Differential and transaction log 3. MSDB: Full and Differential 4. Tempdb: NA Let’s try the practical. Master: Model: MSDB: Tempdb: In Above screenshots we can see possible backup types. If we can try using T-SQL then we will get error message. EX: Msg 3024, Level 16, State 0, Line 3 You can only perfo...