patternsqlMinor
Taking a backup of a single table in the SQL Server
Viewed 0 times
thesqlsingletakingservertablebackup
Problem
I know how to take a backup of a database in SQL Server and restore it. But how can I take a backup of a single table, and then restore it? Is it possible?
I have a database with two different names (some different data) and I have to restore one table by taking it from one database to the other. How can I take a single table backup from one database and then restore it to the other one?
I have a database with two different names (some different data) and I have to restore one table by taking it from one database to the other. How can I take a single table backup from one database and then restore it to the other one?
Solution
Right click the database; Tasks, Generate Scripts & enable Script Data from the options. Select the table and Finish.
This will generate a
This will generate a
CREATE TABLE followed by INSERTs for the data.Context
StackExchange Database Administrators Q#25755, answer score: 7
Revisions (0)
No revisions yet.