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.
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass