Post reply

Replication with 1 hour latency

  • May 19, 2009 at 2:55 pm

    #204474

    First off I'm a newbie flying by the seat of my pants. Anyway, I have a question similar to a previous post today on advice for replication. I learned from that post that transactional replication will require a change to the DB structure to accommodate the replication. I know that this will break my application.

    So is there a replication technology that will provide a copy of the production DB (1 hour latency is fine) that I can use for reporting purposes only? There is no need for this reporting db to be backed up and also no changes will be made to this reporting DB.

    I have SQL 2005 Standard in an active passive cluster running on Windows Server 2003 64bit.

    Thanks,

    TKE402

  • May 19, 2009 at 3:22 pm

    #997272

    Transactional replication will break your application if you do not have PK and you are going to create it. Other than that, transactional replication is the safest bet with minimum latency.

    Another option for you is SnapShot replication. But it depends on how large the DB is and how busy the DB is. Snapshot replication can cause blocking when snaphots are done. You can schedule it to happen once every hour if I am not mistaken.

    -Roy

  • May 19, 2009 at 3:39 pm

    #997276

    Thanks for the reply.

    I thought snap shots were only for SQL 2005 enterprise edition? I'm on standard.

    My third party vendor says that transactional replication will definitely break the app. They had another customer do it and it broke the app. So I believe there is no PK

  • May 19, 2009 at 3:55 pm

    #997282

    You might take a look at log shipping.

  • May 19, 2009 at 4:48 pm

    #997313

    TKE402 (5/19/2009)

    Thanks for the reply.

    I thought snap shots were only for SQL 2005 enterprize edition? I'm on standard.

    My third party vendor says that transactional replication will definitely break the app. They had another customer do it and it broke the app. So I believe there is no PK

    you are probably thinking of database snapshots, which are read only static views of a database at a point in time, that feature is only available in enterprize edition. Snapshot replication (a full copy of the whole publication) is available in standard edition.

    ---------------------------------------------------------------------

Viewing 5 posts - 1 through 4 (of 4 total)

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