When you restore your transaction log, SQL Server will replay all transactions that are in the transaction log and roll forward or roll back transactions that it needs to prior to putting the database in a useable state.Įach of these transactions has a LSN (logical sequence number) along with a timestamp, so when restoring the transaction log you have the ability to tell SQL Server where to stop reading transactions that need to be restored. When data is written to your database it is first written to the transaction log and then to the data file after the transaction is complete. In order for this option to work, the database needs to be either in the FULL or Bulk-Logged recovery model and you need to be doing transaction log backups. This gives you the ability to restore a database prior to an event that occurred that was detrimental to your database. WITH STOPAT option allows you to restore your database to a point in time.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |