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 !!

• March 20, 2018 at 11:24 pm

  This was removed by the editor as SPAM

• March 22, 2018 at 7:00 am

  This was removed by the editor as SPAM