Solved

backup one table option?

Posted on 2011-02-18
2
320 Views
Last Modified: 2012-05-11
does the latest version (denali/R2?) offer any new option to backup only one table?

thanks
0
Comment
Question by:anushahanna
2 Comments
 
LVL 8

Accepted Solution

by:
dba2dba earned 500 total points
ID: 34928899
SQL Server does not support table level backups, unless of course the table in question is allocated to it's own FILEGROUP and the file group can be backed up using BACKUP DATABASE Command.

As an alternative, you could Export the table data to a CSV file. Now in order to get the definition of your table you can 'Script out' the CREATE TABLE script and any associated objects - triggers, indexes etc.

Some third party tools like Quest's Litespeed (enterprise edition) has object level backups.

Thanks,
0
 
LVL 6

Author Comment

by:anushahanna
ID: 34929555
thank you dba.
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Extract string portion 2 24
Sql Query with datetime 3 24
SQL Help 27 45
SSRS 2013 - Creating a summarized report 19 37
This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question