durai nagarajan (1/13/2013)
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.
No. Like Gail and Lynn have stated, you can only go as far back as the last full backup that you have. Log restores are only "roll forward" and cannot be used to "roll back".
It's actually good that you would need to get VP approval to go back earlier than that. That means that something has gone seriously wrong and, since the VP didn't tell you to do it, it means the VP doesn't know that something desparate needs to be done. Don't look at it as a hurdle. Look at it as a safeguard that's gonna cover your butt in the long run.
--Jeff Moden
Change is inevitable... Change for the better is not.