unable to shrink log file

• adisql

  SSCrazy

  Points: 2893

  More actions

  March 20, 2018 at 3:56 pm

  #333953

  Hi,

  log_reuse_wait_desc is OLDEST_PAGE for a database in sys.databases.
  Please suggest how to shrink the log file.

  Thanks

• adisql

  SSCrazy

  Points: 2893

  More actions

  March 20, 2018 at 4:47 pm

  #1984072

  I was able to shrink the log file after issue checkpoint.
  Thank you !!