Hi,

Thanks for the reply,

Here i go with the exact requirement

We have implmented ERP recently with sql server 2008 database. we are facing some of the issues with client data..so we want to take a backup and put it in local server for the testing..

And this we are doing through .bak file only

On this process we dont need to export all the tables since some of the tables having only non functinal data which is not at all usefull for testing and those are occupying half of the database size..

And if i take full backup, it will be time consuming to move the file or to upload the file with total size.

Please suggest....