Post reply

Backup and restore table in SQL 2005 using SSIS

  • March 5, 2008 at 1:18 am

    #154173

    Can we back up selected tables from a database to a file in SQL Server 2005 If it's possible, what is the command?

    Also i need to know how to restore the backup in case my ETL fails.

  • March 5, 2008 at 9:41 am

    #785594

    The only way to backup single tables using native SQL Server backup is to put each table in it's own filegroup and do a filegroup backup and restore. Some third party tools will do a single table restore.

    Please see BooksOnLine for backup and restore directions and syntax. If you have any problems, post again.

    Greg

  • March 5, 2008 at 9:44 am

    #785600

    I just realized you're asking about using SSIS. What you're asking about is not backup and restore per se, but exporting a table and importing it if needed. That is certainly possible. Feel free to post questions if you have specific problems or questions.

    Greg

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply