zahidshah (12/6/2010)
After some changes in database, we want to restore the data,we have the trn file
What do you mean by 'after some changes'?
The error indicates that you brought the database online (not that some logs are missing, that would be a mismatched LSN error). Once the database is online (recovered) no further restores can be done. If you want to restore logs, you need to restore the full backup WITH NORECOVERY, then restore the logs WITH NORECOVERY, with nothing happening in between.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability