09-09-2014 06:22 AM
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.