Another thought is not backing up to the same box your db server is on 🙂

Email I got yesterday from a frazzled IT lead ...

We recently had a sbs2003...

Well at least you know what to do now to prevent this in the future. Work on a backup plan. If you have questions there are plenty of articles, help...

John Bell helped out on this. Thanks much for the lesson here.

SELECT sfProducts.prodName, grades.GRADE, grades.MATERIAL, grades.ANSI, grades.ISO_RANGE, grades.COATING, grades.GRADE_DESCRIPTION FROM grades, sfProducts WHERE sfProducts.prodId = 'PL 01220' AND grades.mfgID =...

Thanks Andy,

Changing to

(CHARINDEX(sfProducts.prodName & ' ', ' ' & grades.GRADE & ' ') > 0)

I get

Invalid operator for datatype. Operator equals boolean and datatype equals nvarchar.

Kim