SUSPECT DATABASE URGENT!!!

• Cem Uney

  Mr or Mrs. 500

  Points: 533

  More actions

  December 2, 2005 at 6:48 am

  #364407

  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

   

  Any Helps???

  Cem Uney

  DB Admin

• Helen-84411

  Hall of Fame

  Points: 3320

  More actions

  December 2, 2005 at 7:54 am

  #607359

  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.

  
  Helen
  --------------------------------
  Are you a born again. He is Jehova Jirah unto me

• Cem Uney

  Mr or Mrs. 500

  Points: 533

  More actions

  December 2, 2005 at 8:23 am

  #607385

   

  Thanks

  i will try

• Andrew Hamilton-273580

  Grasshopper

  Points: 14

  More actions

  March 10, 2006 at 9:14 am

  #626015

  Helen

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

  Andrew