Post reply

Use of Logshiping,Replication and DTS.

  • February 11, 2009 at 4:02 am

    #126370

    Hi Guys,

    I need some clarification, my queries are,

    what is the use of logshiping , replication and DTS.

    how to create logshiping ,replication and DTS in sql server 2005, what is the purpose of both, could plz give some information and each one give me one example

    warm regards,

    Pradeep.

  • February 11, 2009 at 5:24 am

    #942017

    Log Shipping---High Availability

    Replication-- For distributing Data/objects across multiple servers

    DTS>SSIS in SQL 2005-- Extract, Transform and Load Data from different sources to SQL server or vice versa

    how to create logshiping ,replication and DTS> SSIS in sql server 2005

    Check BOL for step by step guide

    what is the purpose of both, could plz give some information and each one give me one example

    Purposes are wide:

    These Technologies can be used for high availability, Redundant Data, Distribute data to multiple sites, Transform and load Data into a Central Data Warehouse

    Check this out for a brief overview:

    http://msdn.microsoft.com/en-us/library/ms190202.aspx

  • February 11, 2009 at 6:33 am

    #942062

    beerampradeep (2/11/2009)

    what is the use of logshiping , replication and DTS.

    You can always start with google and also bol. As and when you get issues with the setup you are more than welcome to post here and someone or the other Gurus will help you out.

    Thanks!!

    The_SQL_DBA
    MCTS

    "Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply