The resource database is read only.
Showing content of resource database
The database file and its log file need to be copied:
C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL>copy Binn\mssqlsystemresource.?df DATA
Binn\mssqlsystemresource.ldf
Binn\mssqlsystemresource.mdf
2 file(s) copied.
The instance is started again and the «new» database created:
use master
go
create database [resource_copy] on
( filename = N'C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\mssqlsystemresource.mdf' ),
( filename = N'C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATa\mssqlsystemresource.ldf' )
for attach
go