Converting from a mdf file to a mdb file

• hoolahan

  SSC Rookie

  Points: 39

  More actions

  November 6, 2003 at 9:23 pm

  #65571

  Our mdf (sql server) file has been deleted and not backed

  up, we are having trouble restoring it with a mdf file

  that we do have.

  We have thought about downloading the mdf file from our

  server and then converting it into a ms access file to

  start to rebuild what we do have.

  Is this possible can you convert a mdf file to a mdb file?

  Kind Regards

• nigelrivett

  SSCertifiable

  Points: 5472

  More actions

  November 8, 2003 at 4:16 am

  #481349

  No.

  With an mdf the only thing you can do is attach the database.

  see sp_attach_single_file_db

  And read about backup strategies.

  Cursors never.

  DTS - only when needed and never to control.

  
  Cursors never.
  DTS - only when needed and never to control.