⟩ What is Master Database?
Master database is system database. It contains information about server’s configuration. It is a very important database and important to backup Master database. Without Master database, server can't be started.
Question and Answer:
Home MS SQL Server Architecture
- Share
Popular Answers:
* There is no answer to the above question yet.
More Questions for you:
What are candidate key, alternate key and composite key?
What protocol both networks use?
What are user defined datatypes and when you should go for them?
What are statistics, under what circumstances they go out of date, how do you update them?
Let's assume you have data that resides on SQL Server 6.5. You have to move it SQL Server 7.0. How are you going to do it?
How to determine the service pack currently installed on SQL Server?
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
What is bit datatype and what's the information that can be stored inside a bit column?
What is denormalization and when would you go for it?
What are the different ways of moving data/databases between servers and databases in SQL Server?
