April 23, 2010 at 2:57 pm
Cwe take a backup of single Schema. My SQL Server Database has 10 Schemas but I want to take backup of only 5 Schemas. Is it possible? If yes then how?
Roopesh Uniyal
April 23, 2010 at 7:11 pm
Data + objects? No. You could script out objects, and then you'd need to export the data. SSIS could easily build a package here. What I'd do is build a package that moves all the objects and data to a new database, then run a backup of that.
You could sp_msforeachtable to create a script that moves stuff as well.
April 23, 2010 at 9:19 pm
Can you explain a bit more about the reasons behind wanting to do this?
More information often results in better answers.
Some third party products allow object-level restore:
http://www.red-gate.com/products/SQL_OLR_Native/index.htm
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
April 24, 2010 at 12:20 pm
this is nice to have feature.. i guess this feature is available with Oracle Export.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply