When you first load SQL SERVER you will startup with what
all databases?
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
How many types of triggers are there?
What is the filtered index?
What is sql server used for?
What is nolock hint in sql server 2008
Does sql server use t sql?
What is mssql?
Does group by or order by come first?
How many types of database relationship in sql server?
Explain activity monitors
Why do we use functions?
Do you think BCNF is better than 2NF & 3NF? Why?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
Do you know how to send email from database?
how you can move data or databases between servers and databases in sql server? : Sql server administration
What is the difference between varchar and nvarchar datatypes?