Restore DB command timing out …. | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Restore DB command timing out ….

I am trying to programmatically restore database on a machine. However the operation is timing out. Database is approx. 50 MB.
How can I specify the query timeout for this operation ?
If you’re connecting to the server and performing from a client then checkup server’s query timeout values.
BTW, how’re you connecting? Using SP_CONFIGURE you can specify value for ‘remote login timeout Option’ & ‘remote query timeout Option’. Make sure it doesn’t timeout when scheduled as a job on the server itself. _________
Satya SKJ