I need to know what the Resource Database in SQL Server is, and why can't we see this physical file in the SQL Server installed directory?
+1
A:
The Resource database is a read-only database that contains all the system objects that are included with SQL Server.
The physical file names of the Resource database are mssqlsystemresource.mdf and mssqlsystemresource.ldf. These files are located in :\Program Files\Microsoft SQL Server\MSSQL10_50.\MSSQL\Binn.
ksogor
2010-06-17 05:35:49