Forum Replies Created

Viewing 15 posts - 2,656 through 2,670 (of 2,898 total)

  • RE: SP4 vs SP3 ??

    I've installed SP4 on 2 servers, and left SP3a on 2 other servers. I haven't had to do anything at the client, nor have I had any other problems or...

  • RE: SQL Mail and Replication

    Is it a pull subscription running at the subscriber ?   I just modify the SQL agent job on the subscriber to use email notification when the job fails

  • RE: tables with vertical partition

    Sounds as though the snapshot job at the publisher has never run, so it can't be sent to the subscriber.

  • RE: Replication vs Transation Logshipping

    The most frequent setting for a SQL job is every minute, but if you choose a "contimuosly updating" subscriber, then the SQL job is "never ending" so it's running all the...

  • RE: Value of sp_MSins etc

    If you don't want a snapshot applied at the subscriber, just choose "schema & data already exist".  The Stored procs are used afterwards to apply published transactions to the subscriber. ...

  • RE: Definitively not SQL

    Are you talking about spring or fall ??  I think both are going to be adjusted, but by different amounts.

  • RE: Value of sp_MSins etc

    I don't quite follow what your question is.  I use the default MS SPs during replication, but I can imagine that if I wanted some custom tasks to run instead...

  • RE: replication is taking lots of space

    Could you explain a bit more ?  Which logs ??  The distribution database can grow large, based on your retention period setting.

  • RE: Replication vs Transation Logshipping

    Phil, what do you mean by " .. Also, the minimum interval for replication is 1 one minute."

    If you choose a continuosly updating subscriber, then latency is only a few...

  • RE: Transactional Replication Latency

    Your hardware and communication will have some impact, so you can't get an exact answer here. I wonder how you could measure it ?   Perhaps set up a test replication,...

  • RE: Trans Replication data missing

    Is that table in the same publication as other tables, or is it in its own publication ?  Are other tables missing data ?  Did you create the publication, but...

  • RE: Turn of logging for bcp for snapshot

    Could you explain ?  I don't quite follow what your problem & solution are ?   Where's the bulk insert flag ?

  • RE: Creating a Pull Subscription

    I think you get the data since the subscriber was created.  Set up a little test replication of a small table & try it out.

  • RE: Anonymous Pull Subscription

    If I understand you correctly, than these comments come to mind:

    " ... Recreates snapshot daily at 4 am. ..."

    If you're doing transactional replication, you only need to run the snapshot...

  • RE: can modify the design of table

    I did this with good results when I needed to change the length of a field in a replicated table. -- Specifically: Drop a table from a publication so...

Viewing 15 posts - 2,656 through 2,670 (of 2,898 total)