June 29, 2009 at 3:39 am
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.
June 29, 2009 at 10:57 am
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
Consultant - Straight Path Solutions
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
June 29, 2009 at 7:38 pm
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: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply