Post reply

How to implement Log Shipping Using SSIS ?

  • April 6, 2010 at 11:46 am

    #220990

    Hi All,

    My Application architechture has one centralized data base server with multiple client db (Ms SQL 2005) and different clients has their own database servers at theri own location.

    At the end of day I have to ship the logs from each of the client's database and sync to the centralized database.

    Can any one help me telling step by step method to build SSIS package for log shipping.

    Any response is appreciated...

    Thanks

  • April 8, 2010 at 3:28 am

    #1148109

    RV-813525 (4/6/2010)

    At the end of day I have to ship the logs from each of the client's database and sync to the centralized database.

    Log shipping does not work like this. Log shipping from multiple primary servers to single secondary server is not allowed. Opposite of it possible. You can have single primary server and multiple secondary servers.

    What is need is replication.

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

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