How to backup Table in SQL

Taking backup of SQL Server table is possible in SQL Server. Below are some options to backup a table in SQL Server.

1. Generate Table Script with data
2. Make a copy of table using SELECT INTO
3. Export Data using SSIS to any destination

 

Method 1 : Generate Table Script with data

1 2 3 4 5 6

 

 

Method 2: Make a copy of table using SELECT INTO

Script:

 

7

SELECT * INTO DataBase.dbo.BackUpTable FROM SourceDataBase.dbo.SourceTable

 

Method 3: Export Data using SSIS to any destination [IMPORT / EXPORT Wizard]

The SQL Server Import and Export Wizard can copy data to and from any data source for which a managed .NET Framework data provider or a native OLE DB provider is available. The list of available providers includes the following data sources:

  • SQL Server
  • Flat files
  • Microsoft Office Access®
  • Microsoft Office Excel®

 

 

 

 

 

Advertisements
Leave a comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

%d bloggers like this: