InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 07:11:22 GMT20http://www.sqlservercentral.com/Forums/Topic743443-357-1.aspxYou could automate this by looping through the tables and doing a BCP out for a schema, however that doesn't get views/procs/functions.Jack's suggestion might be the best one.Mon, 29 Jun 2009 19:38:18 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic743443-357-1.aspxThere is no schema level backup in SQL Server. IF you separate the schemas onto their own filegroups or files then you could backup the schemas.Mon, 29 Jun 2009 10:57:34 GMT Jack Corbetthttp://www.sqlservercentral.com/Forums/Topic743443-357-1.aspxHi Guru's, How can we take a backup of set of tables that belongs to a particular schema in a database? For example i have some 22 schemas in my database and now i would like to take backup of all tables that belongs to DBO schema.Thanks,Nagarjun.Mon, 29 Jun 2009 03:39:04 GMTArjunaReddy