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 are the High-Availability solutions in SQL Server and differentiate them briefly?
What is merge join?
What is the difference between push and pull subscription? : sql server replication
What is dirty read?
How many databases can we create in a single server?
What are the different types of indexes?
What is history table in sql server?
What is user-defined functions? What are the types of user-defined functions that can be created?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
Tell me can we use custom code in ssrs?
Explain following error properties?
What are the basic functions for master, msdb, model, tempdb and resource databases?
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
How to concatenate two binary strings together?
What are the difference between primary key and unique key? : sql server database administration