Explore Courses Blog Tutorials Interview Questions
0 votes
in SQL by (6.1k points)
I need to take a backup of a single table along with its data from a database in the SQL Server using a script.

How can I able to do it?

1 Answer

0 votes
by (12.7k points)
edited by

The following query will help you to take a backup of the table along with its data.

select * into mytable_backup from mytable

This will make a copy of table mytable, and every row in it called mytable_backup.

Looking for SQL Tutorial? Join the SQL Course to gain more knowledge on SQL.

Browse Categories