Home Forums SQL Server 7,2000 Backups How to take backup & restore for one table? RE: How to take backup & restore for one table?

  • That's about the only way in SQL2K. There are third party tools, like LiteSpeed that will allow you to restore a table (or other objects) individually but I don't recall if you can backup individual objects (I don't believe so). I agree with MohammedU, DTS or BCP are probably the easiest (read cheapest!) way to go.

    -- You can't be late until you show up.