Backup by Schema Level

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Backups » Backup by Schema Level

Backup by Schema Level

Rate Topic

Display Mode

Topic Options

Author

Message

ArjunaReddy

Posted Monday, June 29, 2009 3:39 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 10:08 PM
Points: 39, Visits: 388

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

Jack Corbett

Posted Monday, June 29, 2009 10:57 AM

SSChampion

Group: General Forum Members
Last Login: Friday, May 17, 2013 12:22 PM
Points: 10,571, Visits: 11,871

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

Steve Jones - SSC Editor

Posted Monday, June 29, 2009 7:38 PM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 3:30 PM
Points: 31,436, Visits: 13,751

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 »

Permissions