-
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.
-
You can use dts to copy the table over.
-
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
-
Yes, you can drop it then copy over from another server with dts in enterprise manager.
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|