durai nagarajan (1/13/2013)
i have asked just to clear my confusion but is there any other work around?
If you mean to restore to a point in time earlier than any full backup that you have, no.
Point in time restores start with a full backup from before whatever point you're trying to restore to and log backups starting after the full backup and continuing in an unbroken chain to the point that you want to restore to.
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