Results 1 to 11 of 11
  1. #1
    Join Date
    Mar 2004
    Posts
    99

    Unanswered: 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)

  2. #2
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313

  3. #3
    Join Date
    Dec 2002
    Posts
    1,245
    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
    Have you hugged your backup today?

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by jpotucek
    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 --
    Code:
    select *
      into my_backup_table
      from my_live_table
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Ditto that...
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  6. #6
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    that's not really a backup though.

    in my mind a backup needs to be a separate file, preferrably on a separate disk.

  7. #7
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    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
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  8. #8
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    subject of the post states "Make a backup of a Table"

  9. #9
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    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

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  10. #10
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    heh, ok. but isn't this a technical forum for geeks?


  11. #11
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    ...obviously you've missed a few infamous posts...
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •