Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

When you first load SQL SERVER you will startup with what
all databases?

Question Posted / veeresh kethari

Answers were Sorted based on User's Feedback



When you first load SQL SERVER you will startup with what all databases?..

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

When you first load SQL SERVER you will startup with what all databases?..

Answer / sonia

guess what you want to ask is that what are the databases
that come by default? 4 - Master, Model, msdb, tempdb.

Is This Answer Correct ?    1 Yes 0 No

When you first load SQL SERVER you will startup with what all databases?..

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

Post New Answer

More SQL Server Interview Questions

If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

0 Answers  

How do triggers work?

0 Answers  

What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

0 Answers  

Does index slows down insert statements?

0 Answers  

Difference between connected and disconnected database in .net with sql server?

0 Answers   Infosys,

What is constraints and its types?

0 Answers  

What are the types of database recovery models?

0 Answers   HCL,

What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

0 Answers  

In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;

5 Answers   Infosys,

what stored procedure can you use to display the current processes? : Sql server administration

0 Answers  

What are the two virtual tables SQL Server maintains for triggers?

3 Answers  

What is a with(nolock)?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories