June 3, 2008 at 12:10 am
Can any one tell me the difference between master and resource system database in SQL Server 2005? and is there any dependancy between resource database and master database?
June 3, 2008 at 2:48 am
Hey,
You may want to post this in the SQL2005>Development forum, as I am not sure that this is a SSIS related question.
From my limited (and I mean extremely limited) knowledge of the workings of the RDBMS, I would say that the master contains all the system related functions, extended stored procedures etc, whereas the resource database contains all the system objects which will be created when a database is created.
But dont quote me on that, in all likelihood completely far off the mark
~PD
June 3, 2008 at 3:12 am
Thanks for reply. Yes surely, I will post the same to the Development forum.
June 20, 2008 at 8:25 am
Master db:
Records all the system-level information for a SQL Server system. This includes instance-wide metadata such as logon accounts, endpoints, linked servers, and system configuration settings. Also, master is the database that records the existence of all other databases and the location of those database files. Additionally, master records the initialization information for SQL Server. Therefore, SQL Server cannot start if the master database is unavailable.
Resource db
The Resource database is a read-only database that contains all the system objects that are included with SQL Server 2005.The Resource database does not contain user data or user metadata.
M&M
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply