Make a backup of a Table

What is the best way (short of backing up the entire DB) to make a copy of a Table so that It can be easily restored. We have a table that we want to make some serious changes to, but I want to make sure I can restore if if I need to (if the changes don't work)check out bcp.exe

http://msdn2.microsoft.com/en-us/library/ms162802.aspx|||For some $$ (but not $$$), there are several vendors with products that permit object level recovery within SQL databases.

SQL Litespeed is one that has saved my bacon on at least two occasions.

Regards,

hmscott|||What is the best way (short of backing up the entire DB) to make a copy of a Table so that It can be easily restored. easiest way --select *
into my_backup_table
from my_live_table|||Ditto that...|||that's not really a backup though.

in my mind a backup needs to be a separate file, preferrably on a separate disk.|||original post didn't ask for a "backup" -- it asked for "the best way to make a copy of a Table so that It can be easily restored"

by that definition, the solution in post #4 fits the requirement quite nicely :)|||subject of the post states "Make a backup of a Table"|||yeah, but you're thinking of backup in the technical (geekspeak) sense, i'm guessing jpotucek was thinking of backup in the generic sense of making a copy in case something goes wrong

:)|||heh, ok. but isn't this a technical forum for geeks?

:)|||...obviously you've missed a few infamous posts...