SQL Server system database templates

If for some reason you need to restore the system databases, you’ll typically find copies of the original system databases in the …\Binn\Templates folder.
 
Below shows the file on a SQL Server 2016 default instance installation:
image1
Details on how to make use of them is found here

Leave a Reply