589689.xyz

[] SQL Server - Logging, Recovery, and the Transaction Log

  • 收录时间:2018-02-25 22:18:59
  • 文件大小:854MB
  • 下载次数:51
  • 最近下载:2021-01-21 17:09:18
  • 磁力链接:
立即下载 复制链接

文件列表

  1. 4. Log Records/18. Demo - Table Creation Pattern.wmv 19MB
  2. 10. Transaction Log Backups/19. Demo - Looking Into Log Backups.wmv 19MB
  3. 7. Recovery and Crash Recovery/14. Demo - Parallel Crash Recovery.wmv 18MB
  4. 6. Transaction Log Operations/25. Demo - Transaction Log IO Latencies.wmv 18MB
  5. 6. Transaction Log Operations/17. Demo - Index Key Column Update.wmv 17MB
  6. 4. Log Records/9. Demo - Examining Log Records.wmv 17MB
  7. 4. Log Records/12. Demo - Modifying Row Contents.wmv 16MB
  8. 10. Transaction Log Backups/17. Demo - Hack-Attach Tail-Of-The-Log Backup.wmv 16MB
  9. 8. Recovery Models and Minimal Logging/13. Demo - Deferred Drop and TRUNCATE TABLE.wmv 15MB
  10. 4. Log Records/20. Demo - Index Page Split Pattern.wmv 15MB
  11. 7. Recovery and Crash Recovery/5. Demo - Undo.wmv 14MB
  12. 4. Log Records/15. Demo - COMPENSATION Log Records.wmv 14MB
  13. 5. Checkpoints/4. Demo - sys.dm_os_buffer_descriptors.wmv 13MB
  14. 10. Transaction Log Backups/15. Demo - Tail-of-theLog After Minimally-Logged.wmv 13MB
  15. 11. Corruption and Other HADR Topics/7. Demo - EMERGENCY-Mode Repair.wmv 12MB
  16. 4. Log Records/19. Demo - Index Root Page Creation Pattern.wmv 12MB
  17. 10. Transaction Log Backups/9. Demo - Backups and Log Clearing.wmv 12MB
  18. 8. Recovery Models and Minimal Logging/5. Demo - Efficient vs. Miminal Logging.wmv 11MB
  19. 6. Transaction Log Operations/15. Demo - Runaway Transaction Log.wmv 11MB
  20. 8. Recovery Models and Minimal Logging/11. Demo - Runaway Transaction Log.wmv 11MB
  21. 6. Transaction Log Operations/11. Demo - Circular Nature of the Transaction Log.wmv 11MB
  22. 5. Checkpoints/15. Demo - Monitoring Checkpoints.wmv 11MB
  23. 11. Corruption and Other HADR Topics/3. Demo - Recreating the Transaction Log.wmv 10MB
  24. 3. Transaction Log Architecture/3. Demo - Transaction Log File Zeroing.wmv 10MB
  25. 9. Transaction Log Provisioning and Management/17. Demo - Removing VLF Fragmentation.wmv 9MB
  26. 6. Transaction Log Operations/18. Demo - The Cost of Page Splits.wmv 9MB
  27. 8. Recovery Models and Minimal Logging/10. Demo - Is That Database Really in FULL.wmv 9MB
  28. 11. Corruption and Other HADR Topics/11. Demo - Reverting From a Database Snapshot.wmv 9MB
  29. 3. Transaction Log Architecture/12. Demo - DBCC LOGINFO.wmv 8MB
  30. 6. Transaction Log Operations/6. Demo - Tracking Uncommitted Transactions.wmv 8MB
  31. 9. Transaction Log Provisioning and Management/7. Demo - Creating a Transaction Log in Stages.wmv 7MB
  32. 6. Transaction Log Operations/19. Demo - Nested Transactions.wmv 7MB
  33. 5. Checkpoints/9. Demo - Checkpoint Log Records.wmv 7MB
  34. 10. Transaction Log Backups/14. Demo - Tail-Of-The-Log Backup.wmv 7MB
  35. 6. Transaction Log Operations/14. Demo - Full Transaction Log.wmv 7MB
  36. 4. Log Records/21. Demo - Ghost Records Pattern.wmv 7MB
  37. 9. Transaction Log Provisioning and Management/19. Demo - Undroppable Transaction Log File.wmv 6MB
  38. 7. Recovery and Crash Recovery/9. Where Does Recovery Stop.wmv 5MB
  39. 11. Corruption and Other HADR Topics/12. Maintaining Synchronous Database Copies.wmv 5MB
  40. 2. Understanding Logging/4. Where are Logging and Recovery Used.wmv 5MB
  41. 9. Transaction Log Provisioning and Management/8. Log File Provisioning.wmv 5MB
  42. 6. Transaction Log Operations/28. Tuning Transaction Log Throughput.wmv 5MB
  43. 1. Introduction/2. Problems From Misconceptions.wmv 4MB
  44. 8. Recovery Models and Minimal Logging/3. Minimal Logging.wmv 4MB
  45. 8. Recovery Models and Minimal Logging/12. Deferred Drop and TRUNCATE TABLE.wmv 4MB
  46. 6. Transaction Log Operations/13. Why Did the Transaction Log Fill Up.wmv 4MB
  47. 5. Checkpoints/14. Checkpoint Monitoring.wmv 4MB
  48. 7. Recovery and Crash Recovery/8. Crash Recovery.wmv 4MB
  49. 9. Transaction Log Provisioning and Management/9. Estimating Transaction Log Size.wmv 4MB
  50. 4. Log Records/4. Log Space Reservation.wmv 4MB
  51. 6. Transaction Log Operations/24. Monitoring Transaction Log IO.wmv 4MB
  52. 6. Transaction Log Operations/16. Minimize the Impact of Logging.wmv 4MB
  53. 6. Transaction Log Operations/22. Flushing Log Blocks to Disk.wmv 4MB
  54. 4. Log Records/7. Log Records in Transactions.wmv 4MB
  55. 3. Transaction Log Architecture/2. Creating or Growing a Transaction Log File.wmv 4MB
  56. 7. Recovery and Crash Recovery/12. Crash Recovery Visualized.wmv 4MB
  57. 2. Understanding Logging/2. Basic Terminology.wmv 4MB
  58. 10. Transaction Log Backups/10. Continuity of the Log Backup Chain.wmv 4MB
  59. 10. Transaction Log Backups/13. Tail-Of-The-Log Backups.wmv 4MB
  60. 6. Transaction Log Operations/3. Log Space Reservation.wmv 4MB
  61. 4. Log Records/13. COMPENSATION Log Records.wmv 4MB
  62. 8. Recovery Models and Minimal Logging/9. Switching Recovery Models.wmv 4MB
  63. 6. Transaction Log Operations/7. Transaction Log Clearing.wmv 4MB
  64. 4. Log Records/2. What are Log Records.wmv 4MB
  65. 2. Understanding Logging/6. Write-Ahead Logging.wmv 4MB
  66. 7. Recovery and Crash Recovery/16. Crash Recovery and RTO.wmv 4MB
  67. 5. Checkpoints/7. Checkpoint and the Log.wmv 4MB
  68. 11. Corruption and Other HADR Topics/16. Log Shipping.wmv 4MB
  69. 9. Transaction Log Provisioning and Management/5. Tempdb Transaction Log.wmv 4MB
  70. 4. Log Records/3. Log Record Contents.wmv 3MB
  71. 2. Understanding Logging/3. Why is Logging Required.wmv 3MB
  72. 4. Log Records/5. Log Record Types.wmv 3MB
  73. 9. Transaction Log Provisioning and Management/2. VLF Fragmentation - Too Many VLFs.wmv 3MB
  74. 11. Corruption and Other HADR Topics/8. DamagedMissing Log of Attached Database.wmv 3MB
  75. 7. Recovery and Crash Recovery/2. Recovery.wmv 3MB
  76. 9. Transaction Log Provisioning and Management/14. Transaction Log File Shrinking.wmv 3MB
  77. 7. Recovery and Crash Recovery/6. Recovery During Restore.wmv 3MB
  78. 4. Log Records/10. Modifying Row Contents.wmv 3MB
  79. 5. Checkpoints/10. Automatic Checkpoints.wmv 3MB
  80. 3. Transaction Log Architecture/10. DBCC LOGINFO.wmv 3MB
  81. 9. Transaction Log Provisioning and Management/10. Configuring Transaction Log Auto-Growth.wmv 3MB
  82. 7. Recovery and Crash Recovery/13. Parallel Crash Recovery.wmv 3MB
  83. 10. Transaction Log Backups/8. Concurrent Log and Data Backups.wmv 3MB
  84. 3. Transaction Log Architecture/8. VLFs and Log Blocks (2).wmv 3MB
  85. 7. Recovery and Crash Recovery/11. Finding the End of the Transaction Log (2).wmv 3MB
  86. 7. Recovery and Crash Recovery/15. What if Crash Recovery is Interrrupted.wmv 3MB
  87. 8. Recovery Models and Minimal Logging/2. FULL Recovery Model.wmv 3MB
  88. 4. Log Records/22. Tempdb Behavior.wmv 3MB
  89. 5. Checkpoints/16. Tempdb Behavior.wmv 3MB
  90. 7. Recovery and Crash Recovery/18. Tempdb Behavior.wmv 3MB
  91. 8. Recovery Models and Minimal Logging/14. Tempdb Behavior.wmv 3MB
  92. 6. Transaction Log Operations/2. Making a VLF Active.wmv 3MB
  93. 11. Corruption and Other HADR Topics/6. EMERGENCY-Mode Repair.wmv 3MB
  94. 5. Checkpoints/6. Checkpoint Mechanism (2).wmv 3MB
  95. 2. Understanding Logging/8. First Steps - Reading and Initial Locking.wmv 3MB
  96. 7. Recovery and Crash Recovery/4. Undo Portion of Recovery.wmv 3MB
  97. 11. Corruption and Other HADR Topics/9. Database Snapshots.wmv 3MB
  98. 5. Checkpoints/5. Checkpoint Mechanism.wmv 3MB
  99. 1. Introduction/3. Course Structure.wmv 3MB
  100. 8. Recovery Models and Minimal Logging/7. Log Backups and BULK_LOGGED.wmv 3MB
  101. 5. Checkpoints/12. Internal Checkpoints.wmv 3MB
  102. 2. Understanding Logging/5. Where are Logging and Recovery Used (2).wmv 3MB
  103. 4. Log Records/16. Rollbacks and Differential Backups.wmv 3MB
  104. 10. Transaction Log Backups/12. Log Backups After Minimally-Logged Operations.wmv 3MB
  105. 7. Recovery and Crash Recovery/17. Fast Recovery.wmv 3MB
  106. 3. Transaction Log Architecture/9. Log Sequence Numbers (LSNs).wmv 3MB
  107. 9. Transaction Log Provisioning and Management/18. Multiple Transaction Log Files.wmv 3MB
  108. 6. Transaction Log Operations/23. Transaction Log Writes.wmv 3MB
  109. 5. Checkpoints/3. Clean vs. Dirty Pages.wmv 3MB
  110. 10. Transaction Log Backups/7. The Transaction Log Eventually Wraps.wmv 3MB
  111. 9. Transaction Log Provisioning and Management/15. Removing VLF Fragmentation.wmv 3MB
  112. 11. Corruption and Other HADR Topics/17. Transactional Replication.wmv 3MB
  113. 11. Corruption and Other HADR Topics/14. Considerations for Database Mirroring and Availability Groups.wmv 3MB
  114. 6. Transaction Log Operations/21. Transaction Log Extended Events.wmv 3MB
  115. 1. Introduction/1. Introduction.wmv 3MB
  116. 4. Log Records/8. Examining Log Records.wmv 3MB
  117. 6. Transaction Log Operations/29. Tuning the IO Subsystem.wmv 3MB
  118. 2. Understanding Logging/12. Next Steps - Committing the Changes.wmv 3MB
  119. 6. Transaction Log Operations/30. Summary.wmv 3MB
  120. 11. Corruption and Other HADR Topics/10. Reverting From a Database Snapshot.wmv 3MB
  121. 4. Log Records/17. Log Record Patterns of Interest.wmv 3MB
  122. 3. Transaction Log Architecture/4. Virtual Log Files.wmv 3MB
  123. 10. Transaction Log Backups/2. Transaction Log Backups.wmv 2MB
  124. 2. Understanding Logging/15. Summary.wmv 2MB
  125. 5. Checkpoints/2. Why Do Checkpoints Exist.wmv 2MB
  126. 3. Transaction Log Architecture/5. How Many VLFs Do You Get.wmv 2MB
  127. 9. Transaction Log Provisioning and Management/4. Too Few VLFs.wmv 2MB
  128. 11. Corruption and Other HADR Topics/13. Principles of Database Mirroring.wmv 2MB
  129. 11. Corruption and Other HADR Topics/2. DamagedMissing Log with Clean Shutdown.wmv 2MB
  130. 10. Transaction Log Backups/5. Initial Log Backup.wmv 2MB
  131. 6. Transaction Log Operations/27. Random Transaction Log Reads.wmv 2MB
  132. 6. Transaction Log Operations/9. Circular Nature of the Transaction Log.wmv 2MB
  133. 4. Log Records/1. Introduction.wmv 2MB
  134. 5. Checkpoints/11. Indirect Checkpoints.wmv 2MB
  135. 11. Corruption and Other HADR Topics/5. EMERGENCY Mode.wmv 2MB
  136. 10. Transaction Log Backups/18. Looking Into Log Backups.wmv 2MB
  137. 2. Understanding Logging/14. The Transaction Has Committed - Now What.wmv 2MB
  138. 10. Transaction Log Backups/20. Summary.wmv 2MB
  139. 3. Transaction Log Architecture/7. VLFs and Log Blocks.wmv 2MB
  140. 8. Recovery Models and Minimal Logging/4. Minimally-Logged Operations.wmv 2MB
  141. 9. Transaction Log Provisioning and Management/6. VLF Management - Initial File Creation.wmv 2MB
  142. 7. Recovery and Crash Recovery/3. Redo Portion of Recovery.wmv 2MB
  143. 6. Transaction Log Operations/12. If the Transaction Log Fills Up....wmv 2MB
  144. 4. Log Records/6. Lock Logging.wmv 2MB
  145. 3. Transaction Log Architecture/6. VLF Sequence Numbers.wmv 2MB
  146. 6. Transaction Log Operations/20. Transaction Log Waits, Latches, and Spinlocks.wmv 2MB
  147. 6. Transaction Log Operations/26. Sequential Transaction Log Reads.wmv 2MB
  148. 10. Transaction Log Backups/4. Full Database Backup Plus Log Backups Strategy.wmv 2MB
  149. 10. Transaction Log Backups/6. Subsequent Log Backups.wmv 2MB
  150. 7. Recovery and Crash Recovery/19. Summary.wmv 2MB
  151. 5. Checkpoints/8. Checkpoint Log Records.wmv 2MB
  152. 7. Recovery and Crash Recovery/7. Recovery for Database Mirroring.wmv 2MB
  153. 9. Transaction Log Provisioning and Management/20. Summary.wmv 2MB
  154. 8. Recovery Models and Minimal Logging/15. Summary.wmv 2MB
  155. 9. Transaction Log Provisioning and Management/13. Monitoring Transaction Log Health.wmv 2MB
  156. 5. Checkpoints/17. Summary.wmv 2MB
  157. 3. Transaction Log Architecture/13. Summary.wmv 2MB
  158. 11. Corruption and Other HADR Topics/15. Transaction Log in Principal and Mirror.wmv 2MB
  159. 11. Corruption and Other HADR Topics/1. Introduction.wmv 2MB
  160. 5. Checkpoints/13. Manual Checkpoints.wmv 2MB
  161. 9. Transaction Log Provisioning and Management/11. Survey - Transaction Log Size Management.wmv 2MB
  162. 8. Recovery Models and Minimal Logging/6. BULK_LOGGED Recovery Model.wmv 2MB
  163. 8. Recovery Models and Minimal Logging/8. SIMPLE Recovery Model.wmv 2MB
  164. 9. Transaction Log Provisioning and Management/16. Removing VLF Fragmentation (2).wmv 2MB
  165. 9. Transaction Log Provisioning and Management/3. Survery - Transaction Log File Size vs. VLFs.wmv 2MB
  166. 10. Transaction Log Backups/16. Hack-Attach Tail-Of-The-Log Backups.wmv 2MB
  167. 11. Corruption and Other HADR Topics/19. Overall Course Summary.wmv 2MB
  168. 4. Log Records/14. Rolling Back a Transaction.wmv 2MB
  169. 2. Understanding Logging/7. Example Data Modification.wmv 2MB
  170. 4. Log Records/23. Summary.wmv 2MB
  171. 6. Transaction Log Operations/5. Tracking Uncommitted Transactions.wmv 2MB
  172. 6. Transaction Log Operations/1. Introduction.wmv 2MB
  173. 2. Understanding Logging/9. What It Looks Like - Initial Locking.wmv 2MB
  174. 10. Transaction Log Backups/11. Preventing Manual Transaction Log Clearing.wmv 2MB
  175. 11. Corruption and Other HADR Topics/4. DamagedMissing Log without Clean Shutdown.wmv 2MB
  176. 6. Transaction Log Operations/8. Tracking Transaction Log Space Usage.wmv 2MB
  177. 9. Transaction Log Provisioning and Management/12. Tracking Transaction Log Space Usage.wmv 2MB
  178. 2. Understanding Logging/10. Next Steps - Changing and Logging.wmv 2MB
  179. 6. Transaction Log Operations/4. Moving Through the Transaction Log.wmv 2MB
  180. 5. Checkpoints/1. Introduction.wmv 2MB
  181. 7. Recovery and Crash Recovery/10. Finding the End of the Transaction Log.wmv 1MB
  182. 11. Corruption and Other HADR Topics/18. Summary.wmv 1MB
  183. 10. Transaction Log Backups/1. Introduction.wmv 1MB
  184. 3. Transaction Log Architecture/1. Introduction.wmv 1MB
  185. 4. Log Records/11. Modifying Row Contents (2).wmv 1MB
  186. 8. Recovery Models and Minimal Logging/1. Introduction.wmv 1MB
  187. 2. Understanding Logging/11. What It Looks Like - Modifications.wmv 1MB
  188. 7. Recovery and Crash Recovery/1. Introduction.wmv 1MB
  189. 2. Understanding Logging/1. Introduction.wmv 1MB
  190. 10. Transaction Log Backups/3. Full Database Backup Only Strategy.wmv 1MB
  191. 9. Transaction Log Provisioning and Management/1. Introduction.wmv 1MB
  192. 2. Understanding Logging/13. What It Looks Like - Committing.wmv 1MB
  193. 6. Transaction Log Operations/10. Wrapping with Multiple Files.wmv 1MB
  194. 3. Transaction Log Architecture/11. DBCC SQLPERF (LOGSPACE).wmv 886KB