SQL Server Performance

Merge Replication Snapshot Issues

Discussion in 'Performance Tuning for SQL Server Replication' started by Gavin Campbell, Mar 3, 2009.

  1. Gavin Campbell New Member

    HI ,
    When i run my merge replication snapshot agent i am getting 'I/O error while writing BCP data-file', which is normally due to disk space. I have over 73GB of space on my drive and by looking at sp_spaceused my table has reserved space of 73153192 KB(about 71GB) and data of 66632600 KB(about 65GB). Does anyone know which one of these values the merge snapshot agent will use to build up the bcp file. Also, is there other files that get created when the snapshot agent runs. I am running the snapshot file on my subscribing box and not the distribution box(there is not enough space) will this cause any issues with the BCP file being very large.
    Also is there an upper limit to the size of the file that can be used in the snap shot?
    The snap shot now always fails and it looks like there should be enough space to hold it, this has worked before but now has failed.
    Any help is appreciated
  2. satya Moderator

    Welcome to the forums.
    I can sense there is a problem with disk or hardware on the server, as it clearly states I/O problem. Have you checked event viewer logs.
  3. Gavin Campbell New Member

    My drives appers to be ok , i have got other databases using the same drive space as the snapshot file and i have got no problems accessing them. Will compressing the snapshot file help and how much compression will it offer on a 65-72GB file

Share This Page