To back up data into an operating system file, perform the following steps:
Use bcp to copy the data from the table into a file. For information about bcp, refer to bcp in the Adaptive Server utility programs manual for your platform.
Drop and re-create the table.
Use bcp to copy the file into the re-created table.
Recreate all views, triggers, stored procedures, constraints, defaults, and so on that referenced the table.
If there are space constraints, and the table needs
a clustered index, consider creating the index before adding the
data to the table, then run update statistics after
the data is added.
