Take the 2-minute tour ×  I have a single database that I put
all tables into with multiple schemas for the different products
I have. I know I can't backup and restore just one schema, but
if I move all tables for a schema into a separate filegroup can
I then back and restore just that schema without affecting other
tables in other schemas? I don't have foreign keys between
schemas, so there would be no conflicts.  Also, can I restore
into a different database just one of the filegroups without
restoring the others?  A while back I decided to stick with just
one database, thinking there was a way to accomplish this. If
there is no way to do this then it is better to create multiple
databases.  share|improve this question  migrated from
stackoverflow.com Dec 22 '11 at 15:44  This question came from
our site for professional and enthusiast programmers.  1 Answer
1  up vote 1 down vote accepted  I don't know of anyway to do a
schema backup or restore in SQL Server. Your solution of putting
all of the schema dat