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
- 7776 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 ddl triggers and types of ddl trigger?
What are the new data types are introduced in sql 2000?
What is SubQuery in SQL Server 2008
How do I trace a query in sql server?
What are the different types of normalization?
How do you start single user mode in clustered installations?
Why I am getting this error when renaming a database in ms sql server?
What do you mean by data manipulation language?
What is attribute relationships, why we need it? : sql server analysis services, ssas
What is the difference between count and distinct count?
What is the difference between dropping a database and taking a database offline?
Define self join in sql server joins?
What objects does the fn_my_permissions function reports on? : sql server security
What command do we use to rename a db, a table and a column?
How to modify an existing stored procedure in ms sql server?
