Thursday 28 March 2019

How to take backup of a table with data in it

Right click on the database.
select the tables you want to take the backup
Next => Next => Finish
Then you will get a .sql file. When ever you need the data you can execute this file in SQL management studio.

No comments:

Post a Comment