Hi every one.

i have a SQL2000 MDF file database that is marked as  SUSPECT but i cannot restore it.

i tried all procedures. including http://www.sql.ru/faq/faq_topic.aspx?fid=123

Cem Uney

DB Admin

Hi,

After putting the db in emergency mode you can retrive the data using BCP if the data is very critical or you can restore from old backup.

OR

Try the suggestion by Jasper Smith in http://tinyurl.com/2ubq2, but first,
make a copy of your mdf file at least.

Thanks

i will try

Helen

Where ever you are, whoever you are .. THANKS for your post you saved me life

Andrew