snapshot agent error

  • I ran a snapshot agent this morning and it seems to have went well, but when I check on the status later, I get an error:

    The uncompressed size of the file 'item_detail_9.bcp' has exceeded the size limit of '2147418111' bytes imposed by SQL Replication's compression support.

    I can't seem to find anything on the web about this. Does anyone have any ideas?

    Thanks,

    -----------------------------
    www.cbtr.net
    .: SQL Backup Admin Tool[/url] :.

  • figured it out by unchecking the compression tick box :sigh:

    -----------------------------
    www.cbtr.net
    .: SQL Backup Admin Tool[/url] :.

  • Still works - thanks for posting especially since you fixed it yourself.

Viewing 3 posts - 1 through 2 (of 2 total)

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