Reputation: 221
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?
Upvotes: 0
Views: 288
Reputation: 873
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.
http://www.google.lv/#hl=ru&source=hp&q=SQL+Server+Resource+Database&aq=f&aqi=&aql=&oq=&gs_rfai=&fp=9fb3269afe873631 FIRST(!!) link
Upvotes: 1