开发者

Resource database in SQL Server

开发者 https://www.devze.com 2023-01-03 14:20 出处:网络
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?开发者_开发问答Did you look at MSDN? It has information on pa

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?开发者_开发问答


Did you look at MSDN? It has information on paths etc

If you still can't see it then it's flagged as "hidden" and/or "system" in NTFS


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

0

精彩评论

暂无评论...
验证码 换一张
取 消