When you first load SQL SERVER you will startup with what
all databases?
- 3 Answers
- 6092 Views
- CompuSol, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mobin sathupally
When we install SQL SERVER totally we got six databases.
Among six four are system databases and remaining two are
user defined databases,
The system databases are 1.Master
2.Model
3.Msdb and
4.Tempdb.
The user defined databases are 1.Northwind and
2.Pubs.
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / 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 |
What is attribute? : sql server analysis services, ssas
How to skip remaining statements in a loop block using continue statements?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
define and explain the differences between clustered and non-clustered indexes.
What are the results of running this script?
what is the information that can be stored inside a bit column? : Sql server database administration
What are the five major components of a dbms?
What is a trigger what are the advantages of trigger?
How to Debug a Stored Procedure?
How do I manually uninstall an instance of sql server 2016?
Difference Between ORDER BY Clause and GROUP BY Clause in SQL?
What is the difference between the 2 operating modes of database mirroring?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
