Which databases are part of SQL server default installation?
Explain the usage of each?
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 does select 1 mean?
What is the difference between functions and stored procedures?
What are the different types of sql server replication? : sql server replication
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
What are recommended options to be used while using db mirroring? : sql server database administration
What are different types of raid levels?
What is the cartesian product of the table?
What is the use of keyword with encryption.
What is unpivot?
What is the datatype of rowid?
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What is a trigger and its types?
What is mean by dml?
What is abstracting periodical?
What is the meaning of lock escalation and why/how to stop this? : sql server database administration