Forum Replies Created

Viewing 15 posts - 1 through 15 (of 16 total)

  • RE: Replication Latency

    Now you are sprouting wisdom!

    I have done exactly that! Created multiple transactional publications on the database with the largest tables being placed in one publication. Now if I...

  • RE: Replication Latency

    Ha ha! I love hearing people tell others to read books on-line. If all the answers were there we wouldn't have forums like this!

    Okay - so...

  • RE: Replication Latency

    Hi thanks for the Responses!

    Dick - can you tell me what the @schema_option = 0x00000000080350DB settings turn on?

    Noel - The -skiperrors is a work around, and definitely...

  • RE: Replication Latency

    Hi all,

    I have a very interesting SS2K vs ss2K5 problem, which I am currently bypassing in hope of a solution.

    My topology:

    -1 publication database in SS2K (600GB)

    -1 SS2K...

  • RE: Invalid object name after synchronize manually replication

    Thanks for the heads up!!!  I never checked the date!!

  • RE: Invalid object name after synchronize manually replication

    Hi All

    I am having a very similar problem.  I have a very large database that is being replicated using one way transactional replication.  I replicate this database to two totally...

  • RE: Defining users

     This maight help.  Bare in mind that Windows security should be utilised above Mixed mode!  Windows/SQL security can be defined by the following list (which...

  • RE: Replication Question

    HI Larry, we have a similar situation - we have used transaction shipping to (in your case) the local server.  The shipping log is implemented by the production server's maintenance...

  • RE: Wierd Issue

    Hi

    There is much debate on optional Optional parameters we have a VLDB with over 50000000 records.  Based on the condition shown above we have found the following optimisations:

  • RE: Starting and Stopping SQL Server Part 1

    Shutting down SQL is easy, it is shutting down replicated servers in sequence and then starting them up again - that is an art!  If anyone has a process /...

  • RE: data replication software

    Yes - that’s exactly what I mean.  I have checked the tables that we are trying to replicate, and I believe these tables were designed without replication in...

  • RE: data replication software

    Hi Homebrew01, 

    We have about 600 tables.  12 of these tables are over 10Million records in size, and yes it is transactional.  The business requirements are two fold, firstly to...

  • RE: data replication software

    Whoops - Sorry about the double post!!! 

  • RE: data replication software

    Hi there,  We have had numerous problems.  Firstly to tell you a bit about our environment.  We have a 100GB MS-SQL2K SP4 database which we are trying to replicate to...

  • RE: data replication software

    Hi there,  We have had numerous problems.  Firstly to tell you a bit about our environment.  We have a 100GB MS-SQL2K SP4 database which we are trying to replicate to...

Viewing 15 posts - 1 through 15 (of 16 total)