Attach SQL 2000 MDF to MSDE 1.0

• rhinoman

  SSC Rookie

  Points: 37

  More actions

  January 11, 2002 at 4:22 am

  #78374

  I am attempting to setup a demo of my SQL based app using MSDE. Have detached the SQL mdf/ldb files and attempted to attach to MSDE.

  I keep getting the error "<xx.mdf> is not a valid database file header, Pageaudit property is incorrect"

  Any suggestions appreciated?

  Thanks

  Graeme Anderson

  rimfire@lexicon.net

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736270

  More actions

  January 11, 2002 at 9:47 am

  #422092

  I think you may need MSDE 2.0. There was a new MSDE for SQL 2000.

  Steve Jones

  steve@dkranch.net

• rhinoman

  SSC Rookie

  Points: 37

  More actions

  January 12, 2002 at 12:42 am

  #422126

  Thanks Steve, got it in one...

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736270

  More actions

  January 12, 2002 at 8:45 am

  #422128

  You are welcome. Glad to help.

  Steve Jones

  steve@dkranch.net