Server Fault is a question and answer site for system and network administrators. 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

In my SQL Server database, I have multiple schemas. I would like to backup only a specific schema's tables to a format that can easily be restored.


  • [dbo].[Trucks]
  • [dbo].[Cars]
  • [unknown].[Trucks]
  • [unknown].[Cars]

How can I backup only the schema [unknown]'s tables and be able to restore them easily?

Also, is it possible to backup a specific schema from a .bak file that contains the entire database?

share|improve this question
up vote 2 down vote accepted

You can't, unless the schema or table(s) reside on their own filegroup.

SQL server only supports backups at the database level or at the filegroup/file level, not at the table (or at any other object's) level.

share|improve this answer

Your Answer


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

Not the answer you're looking for? Browse other questions tagged or ask your own question.