backup one table option?

does the latest version (denali/R2?) offer any new option to backup only one table?

thanks
LVL 6
anushahannaAsked:
Who is Participating?
 
dba2dbaConnect With a Mentor Commented:
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
 
anushahannaAuthor Commented:
thank you dba.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.