Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
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.

Welcome to Intellipaat Community. Get your technical queries answered by top developers!

29.3k questions

30.6k answers

501 comments

104k users

Browse Categories

...