Thanks for the reponse.

But that is not going to work because I am only selecting the records where ISNUMERIC(mycloumn) = 1.

Thanks allot. That #checkfile example worked.

Here is the error message when I run it from query analyzer.

xp_ss_backup did not complete. An error(0,1) was encountered, please check the parameters and their values.

SQLsafe Freeware Edition CLI...

No. The recover models is still FULL. Job is failing both on log backup as well as database backup.

Appreciate your help on this.

Thanks!