Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Backup by Schema Level Expand / Collapse
Author
Message
Posted Monday, June 29, 2009 3:39 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, April 14, 2014 4:27 AM
Points: 44, Visits: 505
Hi 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.
Post #743443
Posted Monday, June 29, 2009 10:57 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 5:31 AM
Points: 10,910, Visits: 12,548
There 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.



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #743816
Posted Monday, June 29, 2009 7:38 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 11:24 AM
Points: 32,781, Visits: 14,942
You 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.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #744105
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse