Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cidr
Posting Yak Master
207 Posts |
 Posted - 2009-02-03 : 08:13:45
|
| Hi There, I really hope someone can help meI've been looking at info from a database via a view and have accidently deleted information.The info is in regards to an employees working time (the time he charges against different projects)His account is still there and the projects he is assigned are intact, however, the time in hours charged has been deleted.There is a backup, however, I want to avoid restoring the back up over the live db. Perhaps there is a way to restore the db as a copy ao that I can take the deleted values and implement them back to the db?Does anyone know of a quick way to restore the information? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-03 : 09:11:35
|
quote:
Originally posted by cidr
Hi There, I really hope someone can help meI've been looking at info from a database via a view and have accidently deleted information.The info is in regards to an employees working time (the time he charges against different projects)His account is still there and the projects he is assigned are intact, however, the time in hours charged has been deleted.There is a backup, however, I want to avoid restoring the back up over the live db. Perhaps there is a way to restore the db as a copy ao that I can take the deleted values and implement them back to the db?Yes,this is the only way. How many records were deleted?Does anyone know of a quick way to restore the information?
|
 |
|
|
cidr
Posting Yak Master
207 Posts |
Posted - 2009-02-03 : 09:42:08
|
| I'd imagine there's no more than a thousand rowsWhen you say, this is the only way, do you mean restoring the backup to replace the data from the live db or, I can restore the backup with a different db name and take copy the rows that I need over to the live db?Thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-03 : 09:43:57
|
| yup. the latter is also a possibility if you have some info (field) on table which identifies the reqd thousand rows. |
|
|
|
|
|
|
|
|
HELP accidentely deleted info from the database