Hi Chris. Thanks for replying
I tried setting to a high number but no look either I' afraid
It is SQL Server Management Studio 2005 that I am using
Regards,
Gerard
.
>I think I would try setting that value to a very high number, rather than 0, and see if it makes it past the 8 minute mark. I had similar problems in SQL Server Management Studio 2005 with timeouts (one doing a restore, another changing the structure of a table), and set 2 different timeout values to 1200 seconds. That did the trick.
>
>You may also want to make sure you have enough disk space, and have disabled any anti-virus software. I ran into a problem with ZoneAlarm's on-access scanning feature and Visual Studio 2005.
>
>>Hi.
>>I am trying to restore a database (Using SSMS) and I get a Timout Period elapsed prior to completion...
>>This happoens after about 8 mins at 60%
>>I have set the option in Tools.Options..Query Execution-Execution Timeout to zero
>>(Whch should not cause a timeout)
>>Is there anotehr setting.
>>
>>Regards,
>>Gerard
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement