Hi, I am new to this stuff, I tried Restoring my database through the script which is as follows: RESTORE DATABASE db FROM DISK='D:db1.bak' WITH NORECOVERY, REPLACE, STATS=10 RESTORE LOG db1 FROM DISK='D:db12.trn' WITH NORECOVERY RESTORE LOG db1 FROM DISK='D:db123.trn' WITH RECOVERY The above script works fine; actually a table was deleted accidentally and I am trying to restore that table by restoring the full back ups + the succeeding transaction log backups. but unfortunately the table doesn't seems to me coming back is the script correct? Please reply
Are you certain that the transaction log backup you are restoring was taken prior to the table deletion?
hello????? Do You people also restore Your Database the same way I am? Is my script correct or I am Missing something? Please reply
The script looks fine. I don't see any reason of table not showing up. Just try to restore the full backuponly i.e. without the t-log backups nad see if you are able to see the missing table? If yes, then restore again and this time with the first T-log and again check if yes, apply one by one and see where the table was missed. If no, then the table must have been deleted before the backup.
Are you sure that both these tlog backups were taken before the table deletion??? If yes then there is no chance that for the table to be missing after restore. Try what Arun suggested and try it with standby option so in case u doesn't need to start from scratch everytime.
If the table was both created and deleted between any two back-ups (full or log) then your only chance would be if you can restore to a point in time that is after the creation of the table, and before the deletion.