Selective Restore

[Zen216]

Hello,
I have inherited our SQL server after the old admin left.
Well, we had an issue yesterday, when an update to our client management application caused the memo notes on two clients to be deleted. Each DB is backed up through maintenece plans to a bak file that is then picked up by tape. Is there a way to selectively restore the data from 2 records in one table on the db?

Thanks everyone..
Running SQL 2000 std sp4.

 

[mutley1]

No,

You'll need to restore the backup to a database of a different name and then do an update to set the production items that have notes missing to what you have in the backup. This is providing you can identify a key (sorry - don't know your table structure) to ensure the right clauses for the update are made.

HTH,

M

 

[JayKusch]

As a side note, there are 3rd party backup apps that allow your to execute object level restores down to the record level.

Along with great compression and speed with these apps is the ability to object level restore and also dig into the tlogs in that is needed.


Thanks

J. Kusch

 

[Zen216]

Thanks guys,,
I thought that might be the case...
Am in the process of retoring to a test server to see about getting at those records...