Jeff Moden (1/13/2013)
There are some mitigating factors such as whether or not the database has been changed to bulk or simple recovery modes but, if no such thing has happened, nightly full backups and hourly log backups will all point and time recovery to virtually any time after the earliest full backup that you have. Recovering to a time after the last scheduled log backup is also possible if the system will allow you to do a "Tail Log Backup" prior to beginning a restore.
thanks jeff, i understand what you are saying but just thought of asking whether any work around is available because in case i need a database in a state it was before 5 week i need to take my VP approval to get the DB from tapes.
Regards
Durai Nagarajan