Which databases are part of SQL server default installation?
Explain the usage of each?
- 2 Answers
- 6971 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / guest
4 key default dbs :-
Master db : Holds info of all dbs located on SQL Server
insytance. Main db (else SQL Server won't work !)
MSdb : Stores info regarding Backups, SQL Agent info, DTS
packages, SQL Server jobs, replication info for log
shipping.
Tempdb : To hold temp objects like global & local temp
tables, sps
Model db: Used in creation of any new database within the
SQL Server instance of which it(model) is a part.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What are the advantages of using third-party tools?
What is sub-query in sql server? Explain its properties.
Explain “row_number()” in sql server with an example?
tell me what is blocking and how would you troubleshoot it? : Sql server database administration
What is the status of services on passive node for failover cluster in sql server? : sql server database administration
What is key set driven?
How to copy the tables, schema and views from one sql server to another?
What are the rules to use the rowguidcol property to define a globally unique identifier column?
Explain the xml support sql server extends?
Can you name a few encryption mechanisms in sql server?
Can sql server be linked with other servers like oracle?
What is sql server schema compare? How we can compare two database schemas?
What Is Rdbms?
How to delete multiple rows with one delete statement in ms sql server?
What is failover clustering overview?
