What does Log Scan do?

• Alan-314321

  Ten Centuries

  Points: 1359

  More actions

  March 15, 2012 at 1:27 pm

  #265839

  Hi,

  Asked the goggle but didn't get the answer. Can anyone explain to me what the SQL log scan do and how often it happens?

  Thanks in advance.

  Alan

• Lynn Pettis

  SSC Guru

  Points: 442447

  More actions

  March 15, 2012 at 2:35 pm

  #1460185

  Can you provide some context to the question?

• Alan-314321

  Ten Centuries

  Points: 1359

  More actions

  March 15, 2012 at 2:43 pm

  #1460186

  Hi Lynn,

  I was reading MCITP 70-432 ebook and came cross this section explaining why tran log won't free up:

  The database is participating in replication and the distribution database is not

  available.

  You have an open transaction.

  Database Mirroring is paused.

  The mirror database is behind the principal.

  A log scan is running.:exclamationmark:

  SQL Server cannot increase the size of a fle quickly enough.

  All of them are easy to understand but one. A log scan is running is something new to me. That's why I decided to do some digging.

  Thanks,

  Alan