What is the difference between Exporting a Database and Backing it up in SQL Management Studio?

Joshua Tay 246 Reputation points
2021-03-17T01:33:38.8+00:00

Hi,

I would like to ask what is the difference between Exporting a Database and Backing it up in SQL Management Studio?

Please see the image below.

78435-exportdb.jpg

Thank you!

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,297 questions
Windows Server Backup
Windows Server Backup
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Backup: A duplicate copy of a program, a disk, or data, made either for archiving purposes or for safeguarding valuable files from loss should the active copy be damaged or destroyed.
465 questions
0 comments No comments
{count} votes

Accepted answer
  1. Vaibhav Chaudhari 38,681 Reputation points
    2021-03-17T04:34:41.637+00:00

    Back up option > Will generate full database backup file with extension .bak and this can be used in another server where you can use Restore option, use the .bak file and have the DB restored in that another server

    See step by step guide - https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/quickstart-backup-restore-database?view=sql-server-ver15

    Import / Export data option > With this option, you can export the data from DB, specify tables to copy or provide a query, select target DB and the data gets copied to target server/db.

    See step by step guide - https://www.mssqltips.com/sqlservertutorial/202/simple-way-to-export-data-from-sql-server

    ----------

    Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

    2 people found this answer helpful.

0 additional answers

Sort by: Most helpful