Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Export/Import


Export/Import

Author
Message
ravisamigo
ravisamigo
SSC Veteran
SSC Veteran (273 reputation)SSC Veteran (273 reputation)SSC Veteran (273 reputation)SSC Veteran (273 reputation)SSC Veteran (273 reputation)SSC Veteran (273 reputation)SSC Veteran (273 reputation)SSC Veteran (273 reputation)

Group: General Forum Members
Points: 273 Visits: 760
Dear All,

One of my teammate deleted the rows in the table on production database.
how to restore only particular table?

I have backup for that db.If I restore that db in test environment, by using export wizard can I get the table with full structure i.e with constraints?

Please advise.


Thanks and Regards,
Ravi
steveb.
steveb.
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2856 Visits: 7195
you will need to restore to another server and then copy the missing data in the table from that server, a single table restore is not possible from a full backup without third-party tools.
ravisamigo
ravisamigo
SSC Veteran
SSC Veteran (273 reputation)SSC Veteran (273 reputation)SSC Veteran (273 reputation)SSC Veteran (273 reputation)SSC Veteran (273 reputation)SSC Veteran (273 reputation)SSC Veteran (273 reputation)SSC Veteran (273 reputation)

Group: General Forum Members
Points: 273 Visits: 760
Thanks for your reply.

I have restored the database in another server.
By using export wizard, I have exported the table to old database but I couldn't see the indexes and constraints in the new table .

Please advise how get the table entire structure( indexes and constraints) along with whole data.

Regards,
Ravi.
steveb.
steveb.
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2856 Visits: 7195
when you script out the table on the restore server you need to select the option to script constraints and then use this script to create your destintion table.

however I feel that this could be the wrong approach, as you stated that the user deleted rows of data in the table,

so you should not need to recreate the tabe just use the existing table as your destination and copy the missing rows of data from your restore server..
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search