WHICH ARE THE DIFFERENT SERVICES IN SQL SERVER ? HOW DO YOU MANAGE THEM ?

Amit Singh

Total Post:565

Points:2825
Posted by  Amit Singh
 1264  View(s)
Ratings:
Rate this:
  1. Amit Singh

    Post:565

    Points:2825
    Which are the different services in SQL Server ? How do you manage them ?

    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

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!