How do I convert a .mdf "file format" database to a regular SQLExpress database RRS feed

  • Question

  • User-850127045 posted

    I know I can 'attach' a .mdf sql express database.  However, is there a way to convert the file format into a regular sql express database?  Will "restore" work on a .mdf? 

    Tuesday, February 25, 2014 4:30 PM


  • User753101303 posted


    Backup/restore should just work fine if you are using a SQL Server Express version which is at least the same version. Using advanced features could also prevent to downgrade to SQL Server Express. It can be checked using http://technet.microsoft.com/en-us/library/cc280724(v=sql.100).aspx

    Edit: not sure what you meant with "Will 'restore' work on a .mdf?". You won't restore directly a mdf file. You'll use first the "backup" statement to create a SQL Server backup file and then you'll use this backup file for your "restore" statement...

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, February 25, 2014 5:40 PM