Interested to Buy Any Domain ? << Click Here >> for more details...
When you first load SQL SERVER you will startup with what
all databases?
- 3 Answers
- 6664 Views
- CompuSol, I also Faced
- E-Mail Answers
Answer Posted / rajesh s. chandan
It depends of Microsoft SQLm Server version.
When we install Microsoft SQL Server 2008 then SQL Server
installer will install following database.
System databases
1.master
2.model
3.msdb
4.tempdb
If we configure replication then it will create
distribution database.
When we install Reporting Services (SSRS) , then it will
install ReportServer and ReportServerTempDB. We could also
install sample databases like AdventureWorks and
AdventureWorksDW.
Whenever, we restart the SQL Server, it will freshly create
tempdb database. Hope this information will help you.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is sql server used for?
What can be used instead of trigger?
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
How to deploy the Report?
on line cluster can we make if yes tell me the procedure
Give an example of why you would want to denormalize a database
What is the difference between createstatement and preparedstatement?
Tell me what is a linked server?
What stored by the master? : sql server database administration
How can you manage sql azure security?
What do you know about normalization and de- normalization?
What is indexed view?
What is the recovery model?
What are the components of dbms?
Where the sql logs gets stored?
