What are the OS services that the SQL Server installation adds?

Answers were Sorted based on User's Feedback



What are the OS services that the SQL Server installation adds?..

Answer / guest

MS SQL SERVER SERVICE, SQL AGENT SERVICE, DTC (Distribution
transac co-ordinator)

Is This Answer Correct ?    4 Yes 1 No

What are the OS services that the SQL Server installation adds?..

Answer / maheswar reddy s

SQL SERVER - is for running the databases
SQL AGENT - is for automation such as Jobs, DB Maintanance, Backups
DTC - Is for linking and connecting to other SQL Servers

Is This Answer Correct ?    0 Yes 0 No

What are the OS services that the SQL Server installation adds?..

Answer / rajender.m

sqlserver:Provides storage, processing and controlled access
of data and rapid transaction processing.

sqlserverAgent:Executes jobs, monitors SQL Server, and fires
alerts, and allows automation of some administrative tasks.

sqlserver analytical services:Supplies online analytical
processing (OLAP) and data mining functionality for business
intelligence

sqlserver browser:Provides SQL Server connection information
to client computers.

sqlserver fulltext search :Quickly creates full-text indexes
on content and properties of structured and semi-structured
data to allow fast linguistic searches on this data.

sqlserver integration services:Provides management support
for SSIS package storage and execution.

sqlserver Reporting services:Manages, executes, renders,
schedules and delivers reports.

sqlserver VSS writer:Provides the interface to
backup/restore Microsoft SQL server through the Windows VSS
infrastructure.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More SQL Server Interview Questions

Explain system rowset functions?

0 Answers  


Why I am getting this error when dropping a database in ms sql server?

0 Answers  


Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

0 Answers  


What is the syntax to execute the sys.dm_db_missing_index_details?

0 Answers  


How do I compare two values when one value(data type) is char and the other is an integer?

3 Answers  






What is raid, and how it can influence database performance?

0 Answers  


How to view existing indexes on an given table using sys.indexes?

0 Answers  


How many databases instances are there in sql server 2000?

0 Answers  


What is transaction server distributed transaction?

0 Answers  


What is a scheduled job or what is a scheduled task?

0 Answers  


What are tables in sql server?

0 Answers  


What is the purpose of the tempdb database?

0 Answers  


Categories