question

Joshlabtech-6194 avatar image
0 Votes"
Joshlabtech-6194 asked ·

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

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-generalwindows-server-backup
exportdb.jpg (85.7 KiB)
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

VaibhavChaudhari avatar image
1 Vote"
VaibhavChaudhari answered ·

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://docs.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

· 1 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you for the answer, and the follow thru links!

0 Votes 0 ·