Take the 2-minute tour ×
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. It's 100% free, no registration required.

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
add comment

migrated from stackoverflow.com Feb 15 '12 at 22:13

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

1 Answer

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
1  
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
add comment

Your Answer

 
discard

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