SQL - Restore Database Community step times out after 10 minutes

Octopus Server
,
1

SQL - Restore Database Community step times out after 10 minutes

When I try to restore a large database, the “SQL - Restore Database” community step times out and fails after 10 minutes. Is there a way to increase the time out value? There are no parameters dealing with timeouts in this step.

2

Hi @ShrapnelStudios!

Thanks for getting in touch. While there’s no parameter for it, you could clone the community step and then add the timeout to the ConnectionContext setting of the script, using $server.ConnectionContext.StatementTimeout. You can set this to a high number, or you can set it to 0 to disable the timeout altogether.

I hope this helps!

1 Like
3

Thank you so much, Justin! This solved my issue!

1 Like