I am using SQL 2005 🙁

Okay thanks Gail, I think I'll leave it until after hours to be on the safe side

Thanks Adi, I'll give that a go

Just to follow up on this, I rebuilt the indexes and everything ran tickety boo again 🙂

Grant Fritchey (4/21/2011)

---

Yeah, that does make a slight difference. OK, let's look at it a different way, have you looked at the wait stats on the server? Are you waiting...

Thank Grant although I should have explained in my first post that the period between switching the auto update on and off was about 3 weeks so I would have...

Shawn Melton (4/12/2011)

---

To add on to that if at all possible I would use a Windows authenticated account, versus a SQL Login (what the sa account is). It adds a...

Okay thanks Gail, I'll do that

I just used this: -

and it seems to fix the...

I just checked the database properties and it looks like auto create stats is set to false

If I expand the statistics node on the table that...

Thanks for all your replies

Thanks Steve, that tells me what I need to know 🙂

Steve means that you should move the old backup to another server, then do the new back up.

When the new backup is complete you can then delete the old backup...

Thanks for your suggestions guys 😉