I have a .bak I am trying to restore to a particular point in time. I have done lots of full backup restores in sql before but this is my first restore I ever tried to a particular point time (ex. april 1, 1:00pm) in sql. I can see in sql how to limit the possible restore sets by specifying a point in time. But when I choose the transactionlog backup I want to restore ( I am assuming I would want to do restore a transaction log, correct me if I'm wrong) I get the following error..
System.Data.SqlClient.SqlError: The log or differential backup cannot be restored because no files are ready to rollforward
I usually pick the "Overwrite Existing Database(With Replace)" option for this. Can someone tell me if this is still correct, or what the correct process would be or what I need to understand??? What particular backupsets do I need to choose? Any advice would be greatly appreciated.