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...

Maintenance Plans Disappear

I recently restored 3 databases. The maintenance plans responsible for
creating the backups for those databases appear to have disappeared after th
e
restoration. I deleted the databases prior to restoration, but did not touc
h
the plans.
Is there a way to make sure that the next time I have to restore the
databases that the plans do not get removed? Is there a way to backup or
export the maintenance plans?
Thanks
MarkDid you restore msdb? Or did you perform a rebuild of the system databases?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Mark Coffman" <MarkCoffman@.discussions.microsoft.com> wrote in message
news:970287BA-384C-49A8-BA53-26E1BE124F57@.microsoft.com...
>I recently restored 3 databases. The maintenance plans responsible for
> creating the backups for those databases appear to have disappeared after
the
> restoration. I deleted the databases prior to restoration, but did not to
uch
> the plans.
> Is there a way to make sure that the next time I have to restore the
> databases that the plans do not get removed? Is there a way to backup or
> export the maintenance plans?
> Thanks
> Mark
>

Maintenance Plans Disappear

I recently restored 3 databases. The maintenance plans responsible for
creating the backups for those databases appear to have disappeared after the
restoration. I deleted the databases prior to restoration, but did not touch
the plans.
Is there a way to make sure that the next time I have to restore the
databases that the plans do not get removed? Is there a way to backup or
export the maintenance plans?
Thanks
MarkDid you restore msdb? Or did you perform a rebuild of the system databases?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Mark Coffman" <MarkCoffman@.discussions.microsoft.com> wrote in message
news:970287BA-384C-49A8-BA53-26E1BE124F57@.microsoft.com...
>I recently restored 3 databases. The maintenance plans responsible for
> creating the backups for those databases appear to have disappeared after the
> restoration. I deleted the databases prior to restoration, but did not touch
> the plans.
> Is there a way to make sure that the next time I have to restore the
> databases that the plans do not get removed? Is there a way to backup or
> export the maintenance plans?
> Thanks
> Mark
>

Maintenance Plans Disappear

I recently restored 3 databases. The maintenance plans responsible for
creating the backups for those databases appear to have disappeared after the
restoration. I deleted the databases prior to restoration, but did not touch
the plans.
Is there a way to make sure that the next time I have to restore the
databases that the plans do not get removed? Is there a way to backup or
export the maintenance plans?
Thanks
Mark
Did you restore msdb? Or did you perform a rebuild of the system databases?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Mark Coffman" <MarkCoffman@.discussions.microsoft.com> wrote in message
news:970287BA-384C-49A8-BA53-26E1BE124F57@.microsoft.com...
>I recently restored 3 databases. The maintenance plans responsible for
> creating the backups for those databases appear to have disappeared after the
> restoration. I deleted the databases prior to restoration, but did not touch
> the plans.
> Is there a way to make sure that the next time I have to restore the
> databases that the plans do not get removed? Is there a way to backup or
> export the maintenance plans?
> Thanks
> Mark
>