question

basit 1 avatar image
basit 1 asked

Which Configuration File check the master database is UP ?

Hi Team, I have one more Question: We the SQL Server Instance is starting from which configuration file it check the Master database is UP.. Thanks Basit
master-data-management
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
WilliamD avatar image
WilliamD answered
If I understand correctly, you want to know how SQL Server knows if the master database is online. When you start SQL Server (the service), the startup command tells the Sqlserver.exe where to find the master database (startup parameters below): ![alt text][1] SQL Server then loads this database and finds out the other databases and loads them. If master cannot be found or loaded, you have a problem! [1]: /upfiles/Capture3.PNG
11 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

The master database is made up of the master.mdf and mastlog.ldf. If these files are not present, the database cannot be brought online. If master is not there, you cannot start SQL Server, so the question of checking if the files are there and the databse is online is irrelevant once SQL Server is online. The location of the master files is dependant upon the choices made at installation time, or if the files were moved after install, what is present in the startup parameters I have shown above.
3 Likes 3 ·
I thinks this parameter will give the Location of Master database . but i can change this file also when we need to move master database . i want to know that is there any config file which confirm that the master database is up.
0 Likes 0 ·
The fact that SQL Server is running proves that master is online, or am I misunderstanding you?
0 Likes 0 ·
the Issue is that which file are required to up the Master database .
0 Likes 0 ·
@basit may be you can tell us why you want to know that and we might understand the question better.
0 Likes 0 ·
Show more comments

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.