Home Forums SQL Server 2012 SQL 2012 - General How to export particular table list from sql server 2005 DB RE: How to export particular table list from sql server 2005 DB

  • vaithi.saran846 - Tuesday, May 23, 2017 8:41 AM

    Eirikur Eiriksson - Tuesday, May 23, 2017 2:30 AM

    Quick question, why not restore the db from a backup and then drop the unwanted tables?
    😎

    Dump is very huge we do not have hardware to store the entier dump and remove unwanted tables..

    One can restore to an external hard drive, clean up, back up and restore again on the target system, externals are less than $50/TB
    😎
    Just do that on a USB3 😉