No. There is no option to selectively backup tables (i.e. there is no
'backup table') in sqlserver. The best you can do is to use filegroup as
suggested by Uri. Another is to bcp the tables out.
You could use free tool, QALite from site to extract the data out as Insert
statements which you can later use.
Rac v2.2 & QALite!
> Hello every,
> I would like to ask that if I only want to backup part
> of tables in a SQL Server database, i.e. if there are 10
> tables in a SQL Server database, I may need to backup five
> of them only.
> I hope everyone can tell me how I can do that step by
> Thank you for your help