Which databases are part of SQL server default installation?
Explain the usage of each?
- 2 Answers
- 7194 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
How do you create a clustered index?
What are the instances when triggers are appropriate?
How does Report Builder support Analysis Services cubes?
What is inline variable assignment?
What is a file group?
What is the difference between count and distinct count?
what is the sql equivaent of the dataset relation object ?
what are the different stages of Report Processing?
How many tables can be joined in SQL Server?
Where views are stored in sql server?
What is cdc in sql server?
What is the difference between the 2 operating modes of database mirroring?
How do I create a trace in sql server?
How many null values we can have in a unique key field in sql server?
What is Dependency Injection and provide example?
