MS SQL -- Master System Database.

[DannielV]

The Master database holds all the system information for an SQL Server

The System Information for an SQL Server for ex.

1. SQL server initialization information
2. Login account details.
3. System configuration settings
4. System error messages
5. Disks available

Apart from the above the Master DB also stores location of all
other databases.If the info of a DB is not found in a Master the user DB will not be found.

The Changes Done In MS SQL 2005 and higher was a Resource DB added to compliment the Master DB in a way that it will compliment the Master DB. The Resource database makes it easy for service packs to be applied or rolled back whenever necessary.

In the prior version Server 2000, whenever a service pack is applied, all the system objects that reside on both system and user databases will be updated, making it more difficult to rollback the change whenever necessary.

But in Server 2005 changes will only be made to Resource DB and will be reflected on all the system and user databases on the instance.
The file names of the Master and Resource database are as follows:

Database Database file Log file

Master Master.mdf Mastlog.ldf

Resource mssqlsystemresource.mdf mssqlsystemresource.ldf


The location:
<Drive>:\Program Files\Microsoft SQL Server\MSSQL.\MSSQL\Data


DannielV
Windows Dept.
WebHosting