Community
Showing results for 
Search instead for 
Do you mean 
Reply

Timeout errors

New Member
Posts: 19
Country: United_Kingdom

Timeout errors

Hi,

 

All of a sudden last friday after a successful backup using the scheduler we started getting errors and the server was running very slowly.  Ive managed to correct the errors and fix the speed problem by manually rebuilding the table indexes on the database (the actdiag tool just gave a timeout error).  Now I'm left unable to run a back as it just sits for a while then errors with "timeout expired". It makes no difference what I set the utility time out to. If I try and take a backup using the SQL Management studio it only gets to 20% after 2 hours and its only a 2GB database.

 

Im open to all suggestions or if anyone knows how to get a better error message than this generic one.

 

Thanks.