PowerShell - Script never completes. Is there a session timeout?
-
Could it be the transfer is actually still running?
Have you tried to restore from any of the backups recently to make sure they work?
-
@dafyre said in PowerShell - Script never completes. Is there a session timeout?:
Could it be the transfer is actually still running?
Have you tried to restore from any of the backups recently to make sure they work?
I don't think the copy is hanging. I find the complete backup on the remote share the following morning and it appears to be in tact. If I verify the file, MS-SQL reports it as valid. I have not done a flat out restore though.
-
I think I found what may be the culprit!
-
@anthonyh that could do it
-
ROFL. Not a problem. Things working as designed. Next!
-
@anthonyh said in PowerShell - Script never completes. Is there a session timeout?:
@dafyre said in PowerShell - Script never completes. Is there a session timeout?:
Could it be the transfer is actually still running?
Have you tried to restore from any of the backups recently to make sure they work?
I don't think the copy is hanging. I find the complete backup on the remote share the following morning and it appears to be in tact. If I verify the file, MS-SQL reports it as valid. I have not done a flat out restore though.
Even though you have likely found the problem, it would probably be a good idea to test a restore of one of those backup files every now and again.
-
@dafyre said in PowerShell - Script never completes. Is there a session timeout?:
@anthonyh said in PowerShell - Script never completes. Is there a session timeout?:
@dafyre said in PowerShell - Script never completes. Is there a session timeout?:
Could it be the transfer is actually still running?
Have you tried to restore from any of the backups recently to make sure they work?
I don't think the copy is hanging. I find the complete backup on the remote share the following morning and it appears to be in tact. If I verify the file, MS-SQL reports it as valid. I have not done a flat out restore though.
Even though you have likely found the problem, it would probably be a good idea to test a restore of one of those backup files every now and again.
I agree 100%. I plan to test for sure.
-
@dafyre said in PowerShell - Script never completes. Is there a session timeout?:
ROFL. Not a problem. Things working as designed. Next!
For what it's worth, my post was intended to be framed from the standpoint of "what am I doing wrong??" rather than "what's wrong with the system?!". I figured I was missing something stupid.
-
@anthonyh said in PowerShell - Script never completes. Is there a session timeout?:
@dafyre said in PowerShell - Script never completes. Is there a session timeout?:
ROFL. Not a problem. Things working as designed. Next!
For what it's worth, my post was intended to be framed from the standpoint of "what am I doing wrong??" rather than "what's wrong with the system?!". I figured I was missing something stupid.
Never hurts to have extra eyes. I didn't even think about the potential for this to be a scheduled job... God, I have a case of the Mondays.
-
@dafyre said in PowerShell - Script never completes. Is there a session timeout?:
@anthonyh said in PowerShell - Script never completes. Is there a session timeout?:
@dafyre said in PowerShell - Script never completes. Is there a session timeout?:
ROFL. Not a problem. Things working as designed. Next!
For what it's worth, my post was intended to be framed from the standpoint of "what am I doing wrong??" rather than "what's wrong with the system?!". I figured I was missing something stupid.
Never hurts to have extra eyes. I didn't even think about the potential for this to be a scheduled job... God, I have a case of the Mondays.
Not your fault at all. I did not mention it in my OP. Whoops. Perhaps I'm the one with a case of the Mondays.
