Exclude a Table from SQL 2005 Backup Maintenance Plan

Hi All,

I'm seeking feedback on a backup issue. I have several databases that I run full backups on nightly (simple recovery) using a SQL 2005 maintenance plan.

Each database has 1 or 2 tables that hold non-critical spam hit data. This data accounts for approximately half the database size and grows daily.

My question: Is there a simple way to skip / exclude 1 or 2 tables during a native SQL backup routine either via SQL maintenance plan of TSQL.

All help is greatly appreciated.

Thanks.

Rick B

Have you considered moving this tables to their own file group. You can then skip backing up this file group. Other choice may to move these tables to another database?

Thanks

|||Supporting Sunil's suggestion to move the table to a different FILEGROUP there is a Books Online topic on this:

Partial Backups (link to it).

Regards,
Boris.|||

Thanks Sunil and Boris. I guess I was leaning towards that way. THanks you for taking the time to reply.

Regards,

Rick Broider