'Can you load a database from an .LFD and .MDF file in Azure SQL

Our database is transferred to us by our vendor daily in the form of a .zip file that contains an .ldf and a .mdf . Is there a way to generate a database from these files in Azure SQL without creating new containers?

sqldatabaseazureazure-sql-database


Solution 1:[1]

The SQL Server database stores data in MDF files. Typically, .mdf is a preferred extension of the primary database file.

You can load a database from an .LDF and .MDF file in Azure SQL using SSMS

  1. To attach a database using SSMS, first, open SSMS connect to the Azure database engine Right-click on “databases” select “Attach”.
  2. On the Attach Database dialog box, click on Add.
  3. On locate database dialog box, locate the database MDF files which you want to use to create the database.
  4. Select the desired database file and click OK.
  5. On attach database file dialog box, you can review the database details in “Database to attach” and database file details in the “database details” box.
  6. Click on OK to attach the database. Once the database attaches successfully, you can view the database in object explorer.

For more information refer this third party document.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 PratikLad-MT

Related Questions