|
|
|
date: Mon, 7 Jul 2008 10:44:52 -0700 (PDT),
group: microsoft.public.sqlserver.replication
back
Re: Can you have transactional replication of blobs?
On Jul 7, 12:27 pm, "Hilary Cotter" wrote:
> did you set max_text_repl size accordingly? If this is not set correctly
> inserts and updates beyond a certain size will fail.
>
> How are you updateing the blobs too. This is a factor depending on your
> replication type, ie immeidiate updating, queued, etc."PeterCwik" wrote in message
>
> news:b3711586-f0d6-4246-a59e-503729d652e6@t54g2000hsg.googlegroups.com...
>
>
>
> >I am having an issue using transactional replication on a SQL 2005 SP2
> > system when trying to replicate an Image data type. The data won't
> > write to the Prod system, let alone replicate. However, when I remove
> > the table from the publication everything works fine. I show no error
> > in the log, but the app may be handling the error. Are there any
> > gotchas with blobs and transactional replication?
> > Thanks,
> > Peter Cwik- Hide quoted text -
>
> - Show quoted text -
max_text_repl size was the issue. I increased the size and everything
worked fine. Odd that not having the size large enough stopped the
app from inserting into the production machine. I would think that
the data would get saved to prod and then fail to replicate. However
not having the size large enough stopped the initial insert to prod.
--Thanks
date: Fri, 18 Jul 2008 07:29:25 -0700 (PDT)
author: PeterCwik
|
|
