Yes, only non-image data required. We don't want to copy often, just for support now and then.

Thanks guys

Hmmmm, separate filegroup and partial backup. Will look into that too. Do you think this preferable to the 'view' solution mentioned earlier? Thanks.

It is in relation to another post where we want to move image data to another linked table. We wanted to automatically get the linked data (currently in the same...

Thanks. The database is not that big (100GB), but it is too big to copy from the client to our office using RDC for example. Also if we try to...

We do full backups daily on that system.

The images are copies of documents that have been printed or scanned. There are too many to efficiently keep on disk as individual...

OK I will look into that, thanks.