Backup individual tables
April 30th, 2007 — ¥ong¥s
Online project management, task software, and free collaboration workspace: AJAXWorkspace
AJAXWorkspace is a free online workspace that offers task tracking software, team collaboration, online calendar, document sharing, and file management for project management and teamwork. |
There are few ways we can backup individual tables. Here are some of them:
- Use BCP or SSIS/DTS.
- 3rd party vendors do it like litespeed (http://www.quest.com/litespeed_for_sql_server/ ). Litespeed on the backend is just really doing a BCP for the most part. They’ve just made it easier by putting a GUI
- Ditto for SQL BackTrack by BMC.