Results 1 to 5 of 5

Thread: Restore deleted columns with data

  1. #1
    Join Date
    Jan 2007
    Posts
    36

    Restore deleted columns with data

    I need to restore a single table which one of my developers has deleted two columns from that table with all datas.

    The copy of that database is on another server ,if some one can show me through EM, a step by step i will appreciate.

    Thank you.

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    You can use dts to copy the table over.

  3. #3
    Join Date
    Jan 2007
    Posts
    36

    Restore deleted coulms with data

    the copy of the back up table has two extra more columns compared to the table i have on this server.Bear with me if it is a silly question i a newbie on SQL server, is there any way of prompting to drop the current table and replace it with the backup table ?.remember these two db are on different servers

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    Yes, you can drop it then copy over from another server with dts in enterprise manager.

  5. #5
    Join Date
    Jan 2007
    Posts
    36
    Thank you Rmiao

Posting Permissions

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