Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We need to transport database backups over a lower bandwidth connection. We only want the data of specific tables, not the whole database.

In SQL Server 2008 R2, how can this be done? I am attempting to find the solution with the least amount of programming or scripting.

share|improve this question

migrated from Feb 15 '12 at 22:13

This question came from our site for professional and enthusiast programmers.

The smallest for of a BACKUP DATABASE can only be a filegroup. So in other words, if your tables are all confined to a selective filegroup you could achieve your goal through backing up that filegroup.

But I'm guessing that you probably don't have all of your backup-desirable tables in one filegroup isolated from the rest. In which case you'll have to get a little creative.

What I'd do is just script out your desired tables. You can do this by right-clicking your database and selecting generate scripts. Walking through that wizard you can select the specific database objects to script out. You can also set the option to back up both schema and data.

share|improve this answer
Scripting only the updated rows, if practical, and compressing the resulting file would further reduce the bandwidth required. – user92546 Feb 15 '12 at 16:09

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.