Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 resource database

Author  Topic 

Oliver wang
Yak Posting Veteran

50 Posts

Posted - 2012-08-15 : 23:11:55
Hi everyone,

I have a question regarding "resource database" whose explanation is: "Is a read-only database that contains system objects that are included with SQL Server. System objects are physically persisted in the Resource database, but they logically appear in the sys schema of every database." My understanding on it is that all the system objects are physically stored in resource database but logically appear in dabases such as master, msdb and so on. If my opinion is correct, there comes another question, that is why master database sitll takes disc space. Can anyone help to give me some advice? Thank you very much.

regards,

Oliver
   

- Advertisement -