Export/Import

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Export/Import

Export/Import

Rate Topic

Display Mode

Topic Options

Author

Message

ravisamigo

Posted Wednesday, February 02, 2011 2:29 AM

SSC Veteran

Group: General Forum Members
Last Login: Monday, June 10, 2013 6:11 PM
Points: 250, Visits: 708

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

steveb.

Posted Wednesday, February 02, 2011 2:32 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 8:56 AM
Points: 2,802, Visits: 7,110

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

ravisamigo

Posted Wednesday, February 02, 2011 3:31 AM

SSC Veteran

Group: General Forum Members
Last Login: Monday, June 10, 2013 6:11 PM
Points: 250, Visits: 708

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

steveb.

Posted Wednesday, February 02, 2011 3:35 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 8:56 AM
Points: 2,802, Visits: 7,110

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 »

Permissions