"Leila" <Leilas@hotpop.com> wrote in message
news:uuPobGYBHHA.3620@TK2MSFTNGP02.phx.gbl...
> Hi,
> My publication has a large table (about 1GB) and snapshot agent times out!
> Then its status becomes 'retrying'. I have another copy of this DB that
> this table is smaller and the snapshot agent succeeds. The agent does not
> reach to bulk copy phase, it fails while 'preparing...'!
> Any help would be greatly appreciated,
> Leila
>

"Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
news:egk897YBHHA.3380@TK2MSFTNGP04.phx.gbl...
> Can you enable logging to see where it is failing? Here is a link which
> tells you how to enable logging.
>
> http://support.microsoft.com/default.aspx?scid=kb;en-us;312292&sd=tech
>
> You might have greater success with using the concurrent snapshot setting.
>
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
>
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
>
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
>
>
> "Leila" <Leilas@hotpop.com> wrote in message
> news:uuPobGYBHHA.3620@TK2MSFTNGP02.phx.gbl...
>> Hi,
>> My publication has a large table (about 1GB) and snapshot agent times
>> out! Then its status becomes 'retrying'. I have another copy of this DB
>> that this table is smaller and the snapshot agent succeeds. The agent
>> does not reach to bulk copy phase, it fails while 'preparing...'!
>> Any help would be greatly appreciated,
>> Leila
>>
>
>