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


Please Help Members By Posting Answers For Below Questions

How many types of triggers are there?

548


What is the filtered index?

530


What is sql server used for?

521


What is nolock hint in sql server 2008

602


Does sql server use t sql?

495






What is mssql?

549


Does group by or order by come first?

520


How many types of database relationship in sql server?

536


Explain activity monitors

589


Why do we use functions?

487


Do you think BCNF is better than 2NF & 3NF? Why?

755


explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

1957


Do you know how to send email from database?

523


how you can move data or databases between servers and databases in sql server? : Sql server administration

462


What is the difference between varchar and nvarchar datatypes?

554