In this article, We learn how to export(Backup) SQL Database in SSMS in Local Machine. I will show how to do it, and just follow the steps clearly.


Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications which may run either on the same computer or on another computer across a network.

To explore more about MSSQL, just click this link or tap the image below.

SQL Server Management Studio

SQL Server Management Studio is a software application first launched with Microsoft SQL Server 2005 that is used for configuring, managing, and administering all components within Microsoft SQL Server.

SQL Server Management Studio is a free multipurpose integrated tool to access, develop, administer, and manage SQL Server databases, Azure SQL Databases, and Azure Synapse Analytics. SSMS allows you to manage SQL Server using a graphical interface.

SSMS can also be used to access, configure, manage & administer Analysis services, Reporting services, & Integration services.

Export Database in SSMS

First connect to your MS SQL Server and select the expected DB to backup.

  1. Right Click the database, Select Tab Tasks and under that tab Select “Export Data-tier Application”.

2. Click the button next to proceed the process.

3. Select or browse the path where you want to save in your local machine and Next.


Wait until the process if finish and done.

Thank you for visiting my blog site. Hoping you learn more here. please feel free to comment and suggest if there is need to enhance and update. thank you.

Related Topics

One Reply to “Export(Backup) SQL Database in SSMS in Local Machine”

Leave a Reply

Your email address will not be published. Required fields are marked *