HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Taking a backup of a single table in the SQL Server

Submitted by: @import:stackexchange-dba··
0
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?

Solution

Right click the database; Tasks, Generate Scripts & enable Script Data from the options. Select the table and Finish.

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.