In most situations, the right point in time for a database restore is the most recent state of the database before failure. Sometimes the database becomes incorrect in a little different way, for example, when some tables or other objects are lost. When such a situation occurs, it is recommended that you know how to recover the database. SQL Server provides very useful mechanisms to restore a database to the desired but not the last moment. The first option is to set a date and time for data recovery, and the second is to use a transaction log mark. We will go through both options in the form of examples.
Let's see a database called accounting. It is the same database as in the previous section. Full backup executed ...
