DBA Interview Question# Can we create a snapshot for MSDB system database?
Recently I have been approached for one of my technical friend regarding the snapshot for system databases i.e. Master, Model. MSDB & TempDB whether possible or not.
As per Microsoft recommendation, snapshot is prohibited for Master, Model & TempDB so the question is here what about the MSDB snapshot, is it possible to generate?
Can we create a snapshot for MSDB system database?
Here I am sharing the details as an answer with you all after having done a practical on it.
The answer is yes, we can create the snapshot for MSDB system database.
If we try to generate the snapshot for other system databases then we will get the error as below: