Forum Replies Created

Viewing 15 posts - 2,521 through 2,535 (of 2,897 total)

  • RE: Cannot see Publications on remote server

    I think the reason we needed a "push" subscription was that although the ports were open, our remote web server (publisher) would not allow requests from other servers, it had...

  • RE: Name Conflicts

    Those options refer to how the existing table and data at the subscriber are treated when the next snapshot runs. Depending on you requirements, you will favor one of those...

  • RE: Replication fails - transaction log full

    Then your recovery model is probably set to FULL, meaning you are logging all those transaction. You can change it to SIMPLE for just that database, provided you do not...

  • RE: Moving Snapshot files

    In Enterprise Manager, select Properties for the publication, then Snapshot Location tab. Uncheck "Default location" and enter your preferred snapshot location in the box below.

  • RE: Replication fails - transaction log full

    Claudia, did you determine what your recovery model is ?  (full, simple or bulk-logged).  Our subscription databases are simple because we don't need to log all the transactions that occur...

  • RE: Transactional Replication Error

    Not sure if this applies ... but ...

    When I replicated large amounts of data, I had to use a different Distribution Agent Profile. For example, I created a profile with:...

  • RE: Cannot see Publications on remote server

    Are the servers in different domains ?   If so, you might need to create a "push" subscription on the same server as the publisher instead of a "puul" subscription at...

  • RE: SQL Replication - restricting deletes

    These are my thoughts on this .......  Let me know if I'm wrong:

    Disabling DELETEs may give you unexpected results. For instance if the primary key is UPDATED at the publisher,...

  • RE: Splitting Database into multiple files

    DBCC SHRINKFILE with the EMPTYFILE sounds like what I want, but it's not working. I created additional files, both in the PRIMARY filegroup and SECONDARY. I ran...

  • RE: How to replicate only INSERT and UPDATE Statements

    Another "gotcha" could be IF you reinitialize the subscription for some reason. Then when the data from the publisher is re-snapshotted and sent to the subscriber, it will wipe out the current...

  • RE: Backup plan goes wrong

    Sometimes the Job History doesn't give the full story. In addition, I like to write out a log by going into each job step. then the "advanced" tab and setting...

  • RE: Moving database from current server to a new one

    You might want to run SQL Server 2005 Upgrade Advisor against your 2000 database to find out what areas need fixing before it gets converted to 2005. I just downloaded...

  • RE: Job History size

    I have mine set to 50,000 and 1,000.  The default settings are too low for us.  I doubt it affects performance much. 

  • RE: Restore a db

    And do you have a full backup & uninterrupted transaction log backups from before the problem occured ?

  • RE: Changing Column width in replicated table

    Sorry, I haven't used merge replication.

Viewing 15 posts - 2,521 through 2,535 (of 2,897 total)