How do I save a Microsoft SQL database File?

How do I save a SQL database file?

1Open SQL Server Management Studio Express and connect to the SQL server.2Expand Databases.3Right-click on the database you want to back up, then select Tasks > Back up. ... 4On the Back Up Database window, make sure the Database field contains the name of the database you want to back up.5Select the Backup Type.

How do you save a database file?

To reuse a database or a database object, you use the Save As dialog:1Open the database or database object.2On the File tab, click Save As.3Do one of the following steps: To save a database in a different format, click Save Database As. ... 4Click the format you want to use for the new copy.

How do I save an MDF file?

You can right click in the "Server Explorer" on your db. mdf file and press "Publish to provider..."1detach the database (right click the database and click Detach )2copy the mdf and ldf files to your backup location.3attach the database (right click Databases and click Attach )

How do I create a .SQL file?

Creating a SQL File1In the Navigator, select the project.2Choose File | New to open the New Gallery.3In the Categories tree, expand Database Tier and select Database Files.4In the Items list, double-click SQL File.5In the New SQL File dialog, provide the details to describe the new file. ... 6Click OK.