Home > DeveloperSection > Interviews > Which are the different services in SQL Server ? How do you manage them ?

Posted on    March-28-2011 9:05 AM

 MSSQL Server MSSQL Server 
 1 Answer(s)
  1237  View(s)
Rate this:

Amit Singh

Total Post:565

Posted on    March-28-2011 12:00 AM

Replication Service: SQL Server 2000 replication enables sites to maintain multiple copies of data on different computers, in order to improve overall system performance, while ensuring that all the different copies are kept synchronized.
DTS: By using DTS, you can build data warehouses and data marts in SQL Server by importing and transferring data from multiple heterogeneous sources interactively or automatically on a regularly scheduled basis.
Analysis Services: Analysis Services provides tools for analyzing the data stored in data warehouses and data marts.
Metadata services: SQL Server Meta Data Services provides a way to store and manage metadata about information systems and applications. This technology serves as a hub for data and component definitions, development and deployment models, reusable software components, and data warehousing descriptions.
Reporting services: used to generate reports from the data in the database

Don't want to miss updates? Please click the below button!

Follow MindStick