mdf file recovery

• Madhu Online Services

  Newbie

  Points: 3

  More actions

  June 1, 2007 at 11:54 pm

  #174472

  I have Sql 7.0 and the MDF file is corrupted and i want to recover it beacuse my all datais on that please help me out

• Ian Yates

  SSCoach

  Points: 19738

  More actions

  June 3, 2007 at 4:59 pm

  #710513

  Look at dbcc chekcb in the SQL Server manual (called "Books Online")

• Minaz Amin

  SSChampion

  Points: 11052

  More actions

  June 4, 2007 at 2:00 am

  #710537

  Hi,

  What is the exact error message do you receive?

  1. Try running the dbcc command as suggested earlier.

  2. If you have recent backup restore it.

  3. Try BCP out the data.

  Check the hardware, firmware etc of the current system to know the root cause of the corruption and this is important.

   

  Minaz Amin

  "More Green More Oxygen !! Plant a tree today"