May 27, 2009 at 11:44 am
Somehow most of the data from a single table in a database got deleted. I want to restore just this table from either a back up or from a test version of this same database without overwriting any other data. It is on 2005. Any ideas? Please let me know if you need any additional information.
Thank you
May 27, 2009 at 12:00 pm
You cannot restore a single table from a Back up. Your option would be to
1. Restore your Back up into another Server and export data from that table to the production
2. Export data from test to production.
3. Enter everything manually 🙂
-Roy
May 27, 2009 at 12:01 pm
Restore the backup with a different database name on the same server or different server.Then use import wizard ,which will create the table as well as move the data to your original database.
Hope this helps...
May 27, 2009 at 12:25 pm
Tried exporting but get the following errors:
Error 0xc0202049: Data Flow Task: Failure inserting into the read-only column "TIME_STAMP".
(SQL Server Import and Export Wizard)
Error 0xc0202045: Data Flow Task: Column metadata validation failed.
(SQL Server Import and Export Wizard)
Error 0xc004706b: Data Flow Task: "component "Destination - Demographics" (160)" failed validation and returned validation status "VS_ISBROKEN".
(SQL Server Import and Export Wizard)
Error 0xc004700c: Data Flow Task: One or more component failed validation.
(SQL Server Import and Export Wizard)
Error 0xc0024107: Data Flow Task: There were errors during task validation.
(SQL Server Import and Export Wizard)
May 27, 2009 at 12:57 pm
Don't migrate the timestamp column. It will generate on it's own.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
May 27, 2009 at 1:03 pm
how do I exclude it. I did not see that as an option anywhere?
May 27, 2009 at 1:28 pm
You may have to edit the SSIS package the import/export wizard creates.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
May 27, 2009 at 1:30 pm
Look for the Edit mapping button when your are selecting the source table, this should open a column mapping dialog, in the destination column select the <ignore> option for the relevant field(s).
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply