Backup Database excluding a particular table

[Phil99]

Hi,

Is it possible to run a database backup and exclude a particular table from the backup file.

We have a large database but most of the space is taken up by one table which we would like to exlude from the backup.

Thanks

Phil

 

[JayKusch]

Not if the table resides in the same filegroup as the backup. It is an ALL or Nothing operation. If you move your table to a secondary filegroup known as an NDF, you can back up each filegroup independantly.

Thanks

J. Kusch