Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Export/Import Expand / Collapse
Author
Message
Posted Wednesday, February 2, 2011 2:29 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, November 10, 2014 8:16 PM
Points: 250, Visits: 751
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
Post #1057279
Posted Wednesday, February 2, 2011 2:32 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, May 30, 2014 6:27 PM
Points: 2,808, Visits: 7,175
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.
Post #1057282
Posted Wednesday, February 2, 2011 3:31 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, November 10, 2014 8:16 PM
Points: 250, Visits: 751
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.
Post #1057316
Posted Wednesday, February 2, 2011 3:35 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, May 30, 2014 6:27 PM
Points: 2,808, Visits: 7,175
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..
Post #1057317
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse