Tell me more ×
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.
up vote 1 down vote favorite

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 stackoverflow.com Feb 15 '12 at 22:13

1 Answer

up vote 2 down vote

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

Your Answer

 
discard

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