February 24, 2011 at 8:13 am
Hi all, I posted this already. I tried couple methods to accomplish this, But I couldn't. Can some one walk me through the existing solution or to expedite process explain me other solution If something there. I would really appreciate that. Please find the existing solution
Task: --> Have to do FTP the backup file which is around 20gb(after compressed) from Productions server to Dev server.
-->Schedule a job for this as once in every 2 weeks.
--> Schedule a job on Dev to restore the latest backup(which we just have gotten from prod.)
My Solution: Created a sp which usually does connect the Dev server through command prompt by passing ftp credentials, And drop(put) the backup file in appropriate folder. It will do special log also.
So I am executing this by scheduling a job for every other week.
Once It has done this process,I am restoring that backup file on Dev by scheduling a job.
This is the Task and solution.
Now I am getting issues here, the following are the two things i can see in the log during the process fail.
1) Connection closed by remote host.
2) Netout :Connection reset by peer
Sometimes It is giving me expected results properly with out any of these issues, But most of the times it is failing.
If its more than a kb,mb,gb sometimes getting errors. As well as even its more than 2gb it is working fine. Can some please help me here.
Thanks in advance.
February 24, 2011 at 12:56 pm
Those errors sound like you have a network issue. You should check that first, before you look any more at SQL Server or FTP for the problem.
Chris
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
February 24, 2011 at 1:13 pm
Check the network card properties and see if "Allow the computer to turn off this device to save power." is checked or not. If it is checked, that could be the problem. Unchecking that box could resolve your issue.
February 24, 2011 at 1:25 pm
Hi Rookie Can you please tell me the steps to follow to check the network side. I don't know anything more about networking side. Could you please walk me those steps It will be really helpful to me.
Questions: On which server Do I need to do all these?
Production server or Dev server or The one which uses remotely to have this work done on the Production.
Thanks in advance
February 24, 2011 at 2:31 pm
I would do it on both servers.
Go to property of network connection.
Click -> Configure
Go to Power Management tab
There you will find check box for "Allow the computer to turn off this device to save power"
Make sure its unchecked for all connections on both servers. If there are more than one network cards on server, follow the same for all.
February 24, 2011 at 2:44 pm
Rookie I found that and wondering how this effects the issue which I am getting. What is the relation there with that?
can You please give me the brief explanation, I am totally confused.
February 24, 2011 at 3:00 pm
There could be many different issues. This is one of the possible reasons.
Connection closed by remote host.
which shows your connections are getting disconnected. High probability that its due to network card going into power saver mode.
You can check with one of your OS admins and they should be able to explain in details. I am not good with explaining.
First question is "is that box checked?" if so, then thats could be the issue. I would say try it and see. Also let us know if it worked or not. Make sure, you fix on both servers and all network cards.
February 25, 2011 at 9:28 am
Hi Dave-175556
I have applied this network properties But I first couple times It doesn't support giving the same error. Later I have passed through.
Thank you very much for that Dave-175556.
Still I doubt because this will be happening by job, If the failure occured in the schedule it will be another issue. So could you/ anyone please give me any other possibilities it gets failure. Thanks in advance
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply