Is there a way to backup and restore individual schemas only in SQL Server 05/08

[Discover Antartica]

Hello All,
Is there a way to backup only tables belonging to a specific schema instead of the entire database in SQL Server 2005 or SQL Server 2008? Also, can I restore only a few tables belonging to a schema instead of restoring all the tables in the database?

Thanks All,
DA


     

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists
Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3240
Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.6