SQL Server Restore Database task "Could not restore backup: Timeout expired"

FinalBuilder Bugs
1

I have a restore database task. It is a large database  - FB says "timeout expired" after 30 mins although SQL Sevrer is still restoring the database.

 

The log (from FB server) says:

 

SQL Server Restore Database SQL Server Restore Database 13:11:21 13:41:22 00:30:01
Error

 

Executing SQL ScriptsEnable Single-User ModeALTER DATABASE sys01 SET SINGLE_USER WITH ROLLBACK IMMEDIATERestoreRESTORE DATABASE sys01 FROM DISK='\\r200\sqlbkup\EN-ERP-DB01\ERPP1\BACKUPS\sys01\Day08-Thu-sys01.bak' WITH REPLACE, MOVE 'sys01' TO 'D:\mssql2005\ERPD1\DATA\sys01.mdf', MOVE 'sys01_log' TO 'D:\mssql2005\ERPD1\DATA\sys01_log.ldf'Could not restore backup: Timeout expiredRestore Multi-User ModeALTER DATABASE sys01 SET MULTI_USERCould not restore backup: ALTER DATABASE is not permitted while a database is in the Restoring state

 

2

Hi Mark

I just had a quick look at the code, the timeout is hard coded at 30 minutes, I guess the developer who wrote the code (in 2007) didn’t expect a database restore to take that long. I’ll look at making that timeout configurable on Monday.