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 |
|
kashyapsid
Yak Posting Veteran
78 Posts |
 Posted - 2010-05-13 : 07:52:25
|
| unfortunately in the work i have deleted a table how can i regain the data in the table and the name of the table is FSRD its very important to recollect the data so plz coperateKaShYaP |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-05-13 : 08:02:23
|
Without a backup you have a problem.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
kashyapsid
Yak Posting Veteran
78 Posts |
Posted - 2010-05-13 : 08:58:04
|
| sorry for the delay i am a trainee it was my fault is there any modifications for the backupKaShYaP |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-05-13 : 09:37:53
|
| Take a Tail-backup if necessary (e.g. scheduled backups have not yet run to create a TLog backup SINCE the incident)Restore backup to point-in-time just before the accident to a NEW, and Temporary, database. Do not restore to the actual database!!!Copy the data / table from the Temporary database to the live database.Once that is all completed successfully you can drop the Temporary databaseIf you don't have TLog backups you are hosed (unless you can restore the data, as described above, using the last Full Backup that you have) |
|
|
|
kashyapsid
Yak Posting Veteran
78 Posts |
Posted - 2010-05-14 : 01:16:50
|
| thanks for considering the problem has been rectified i have recovered the data in the tableKaShYaP |
|
|
|
|
|
|
data recovery