Replication problems

I have set up a server with a publication of a very large database. A backup
server needs to retrieve the data and do some massive calculations (which
isn't really relevant). On the backup server I've created a subscription to
retrieve the database but I get the following error:

Message: The process could not retrieve file
'SQLCLUSTER_maersk_HR_maersk_HR\20030804101206\ATT ACH_224.bcp' from the FTP
site '10.25.10.25'.

Details: The process could not retrieve file
'SQLCLUSTER_maersk_HR_maersk_HR\20030804101206\ATT ACH_224.bcp' from the FTP
site '10.25.10.25'.
(Source: AGENT (Agent); Error number: 00000)
----------------------------------------------------------------------------
-----------------------------------

Now this file IS available and the server CAN connect to the FTP site since
it happens and it downloads a lot of other files/scripts before reaching
this one. The file is around 200 MBs which I suspect is the reason why. I
even have a table of 1.29 GBs I need replicated as well.

Does anybody know what goes wrong? Is there some sort of script timeout
setting I can adjust somewhere to get this to run properly?



=8-) Simon

re: Replication problems

"Simon B. Nielsen" <simon@webplanet.dk> wrote in message
news:EWqXa.45089$Kb2.1927005@news010.worldonline.d k...[color=blue]
> I have set up a server with a publication of a very large database. A[/color]
backup[color=blue]
> server needs to retrieve the data and do some massive calculations (which
> isn't really relevant). On the backup server I've created a subscription[/color]
to[color=blue]
> retrieve the database but I get the following error:
>
> Message: The process could not retrieve file
> 'SQLCLUSTER_maersk_HR_maersk_HR\20030804101206\ATT ACH_224.bcp' from the[/color]
FTP[color=blue]
> site '10.25.10.25'.
>
> Details: The process could not retrieve file
> 'SQLCLUSTER_maersk_HR_maersk_HR\20030804101206\ATT ACH_224.bcp' from the[/color]
FTP[color=blue]
> site '10.25.10.25'.
> (Source: AGENT (Agent); Error number: 00000)
> --------------------------------------------------------------------------[/color]
--[color=blue]
> -----------------------------------
>
> Now this file IS available and the server CAN connect to the FTP site[/color]
since[color=blue]
> it happens and it downloads a lot of other files/scripts before reaching
> this one. The file is around 200 MBs which I suspect is the reason why. I
> even have a table of 1.29 GBs I need replicated as well.
>
> Does anybody know what goes wrong? Is there some sort of script timeout
> setting I can adjust somewhere to get this to run properly?
>
>
>
> =8-) Simon
>[/color]

You'll probably get a better response by posting this on
microsoft.public.sqlserver.replication. This newsgroup posting seems to be
about the same issue, but it's quite old, and there's no actual solution:

http://groups.google.com/groups?hl=e...%40tkmsftngp05

Simon

re: Replication problems

"Simon B. Nielsen" <simon@webplanet.dk> wrote in message
news:EWqXa.45089$Kb2.1927005@news010.worldonline.d k...[color=blue]
> I have set up a server with a publication of a very large database. A[/color]
backup[color=blue]
> server needs to retrieve the data and do some massive calculations (which
> isn't really relevant). On the backup server I've created a subscription[/color]
to[color=blue]
> retrieve the database but I get the following error:
>
> Message: The process could not retrieve file
> 'SQLCLUSTER_maersk_HR_maersk_HR\20030804101206\ATT ACH_224.bcp' from the[/color]
FTP[color=blue]
> site '10.25.10.25'.
>
> Details: The process could not retrieve file
> 'SQLCLUSTER_maersk_HR_maersk_HR\20030804101206\ATT ACH_224.bcp' from the[/color]
FTP[color=blue]
> site '10.25.10.25'.
> (Source: AGENT (Agent); Error number: 00000)
> --------------------------------------------------------------------------[/color]
--[color=blue]
> -----------------------------------
>
> Now this file IS available and the server CAN connect to the FTP site[/color]
since[color=blue]
> it happens and it downloads a lot of other files/scripts before reaching
> this one. The file is around 200 MBs which I suspect is the reason why. I
> even have a table of 1.29 GBs I need replicated as well.
>[/color]

Well, I suspect a couple of things.

The obvious, sure that's the right file? (I'm guessing it's a time stamp in
there?)

Is it possible the file is still be created?

When you say the server does other things, I'd tend to rule out permissions
and user context, but always a good place to start.

200 MB should not be a problem to FTP, but their may be a timeout you need
to reset. (can't recall where off the top of my head.)

[color=blue]
> Does anybody know what goes wrong? Is there some sort of script timeout
> setting I can adjust somewhere to get this to run properly?
>
>
>
> =8-) Simon
>
>[/color]