durai nagarajan (8/21/2012)
In that case he has not scheduled Tlog backup from 6:00PM to 10:00PM which in turn might leave him in data loss incase of disaster.with full backup and next day TLog are you saying that sql engine will restore only the required details from log and not all the details from the TLog if it is restored?.
The plan was to have TLOGS only from 6AM - 6PM. We are okay with the transactions in b/w.
[font="Verdana"]
Today is the tomorrow you worried about yesterday:-)[/font]