What are the challenges you face when working across database platforms? Take the survey

Backup/Restore Specific Tables?

ChristianASPNETChristianASPNET Posts: 7
edited February 22, 2005 1:45PM in SQL Backup Previous Versions

I work for a company that develops data warehouse solutions. We have a need to backup database schema and specific metadata tables. It's not necessary at all to backup the fact and dimension tables (which can be VERY large), since these are regularly rebuilt from source data.

Does Red Gate's SQL Backup have this capability? If not, is this something that might be added in the future, or would you recommend a different solution (perhaps using the SQL Toolkit)?

Best Regards,
David Neal


  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1

    SQL Backup is simply a drop-in replacement for native SQL Backup that addresses storage and security shortcomings in the backup functions of SQL Server. In its' current form, it can back up entire databases, but not individual tables or a cross-section of tables from many databases.

    This sort of problem is best addressed by SQL Packager, which can create a self-running SQL script that will reproduce the schema and data that you pick from a database.

    SQL Packager can also be automated as part of the SQL Toolkit, if you need to create many packages to reproduce a few databases. SQL Backup doesn't have this option, mainly because you can already perform all of the SQL Backup functions from the command line or by executing a query in SQL Query Analyzer.

    Please let us know if you have any more questions.
Sign In or Register to comment.