Just looking for some verification. In order to do point in time recovery of a SQL Server database (or any database for the most part) I need to have a valid database backup and all the associated transaction log backups to the point in time that I want to recover too, correct?
In other words if I wanted to restore my database to say 1pm this afternoon, I need to have a backup from last night (say 2am) and a backup of all the transaction logs going back to 1pm this afternoon. I cannot restore the database via point in time with out those transaction log backups correct?
My boss is trying to tell me that I can do a point in time restore just by having last nights DB backup and also the current transaction log file that has been excepting transactions throughout the day with no transaction log backups at all. I'm trying to tell him that that isn't possible?
High points on this because I'm trying to prove my boss, who never listens, wrong.
Any help is greatly apprecaited.