How to take a table-level backup in SQL Server 2008

1149690 pts.
Tags:
Backup
SQL Server 2008
Does anyone know how to take a table-level backup in SQL Server 2008? Can we use the backup database command? Thank you!
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

I don’t think the backup database command can backup an individual table, but you can “export” your table from Management Studio.

Right-click on the table and look for the option to generate the table creation script, making sure you select the appropriate settings to also include the data in the resulting export file.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Elizine

    Backup Types are dependent on SQL Server Recovery Model. Every recovery model lets you back up whole or partial SQL Server database or individual files or filegroups of the database. Table-level backup cannot be created, there is no such option. But there is a workaround for this

    Taking backup of SQL Server table possible in SQL Server. There are various alternative ways to backup a table in sql SQL Server

    1. BCP (BULK COPY PROGRAM)
    2. Generate Table Script with data
    3. Make a copy of table using SELECT INTO
    4. SAVE Table Data Directly in a Flat file
    5. Export Data using SSIS to any destination
    1,145 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: