Interested to Buy Any Domain ? << Click Here >> for more details...
Which databases are part of SQL server default installation?
Explain the usage of each?
- 2 Answers
- 7796 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 to write a query with a full outer join in ms sql server?
what kind of lan types do you know? : Sql server database administration
What is acid mean in sql server?
How to use subqueries with the exists operators in ms sql server?
Does index slows down insert statements?
How to drop existing views from a database in ms sql server?
What is indexing explain it with an example?
Where the sql logs gets stored?
What is the stored procedure?
What do you think of this implementation? Can this be implemented better?
What is the difference between getdate and sysdatetime?
What's new in sql management studio for sql server? : sql server management studio
What is difference between createstatement and preparedstatement?
where can you add custom error messages to sql server? : Sql server administration
What are the instances when triggers are appropriate?
