You helped. I wasn't having any luck at all making sense of that checkpoint file. :)
From: Michael B. Smith [mailto:mich...@smithcons.com] Sent: Tuesday, September 28, 2010 9:00 PM To: MS-Exchange Admin Issues Subject: RE: Number of Log files played into a database Show off :) Regards, Michael B. Smith Consultant and Exchange MVP http://TheEssentialExchange.com From: Campbell, Rob [mailto:rob_campb...@centraltechnology.net] Sent: Tuesday, September 28, 2010 9:55 PM To: MS-Exchange Admin Issues Subject: RE: Number of Log files played into a database $chk = eseutil /mk e0b.chk ($chk | select-string "fullbackup:").line -match "FullBackup: \((\S+),\S+,\S+\)" $lastbk = $matches[1] ($chk | select-string "\sCheckpoint:").line -match "\((\S+),\S+,\S+\)" $lastckpt = $matches[1] $logs_committed = $lastckpt -$lastbk Write-host "There have been $logs_committed logs committed since the last backup." From: Michael B. Smith [mailto:mich...@smithcons.com] Sent: Tuesday, September 28, 2010 8:24 PM To: MS-Exchange Admin Issues Subject: RE: Number of Log files played into a database I had to work at this one ... I can't find a PowerShell cmdlet way to do it. I expected that "Get-MailboxDatabase -status" would have it, but it doesn't. Gotta go old school: Eseutil /mk e02.chk Or whatever the checkpoint file is for the particular database. You'll get something like this: Extensible Storage Engine Utilities for Microsoft(R) Exchange Server Version 14.01 Copyright (C) Microsoft Corporation. All Rights Reserved. Initiating FILE DUMP mode... Checkpoint file: e02.chk LastFullBackupCheckpoint: (0x0,0,0) Checkpoint: (0x1B63F,80,0) FullBackup: (0x1B189,8,16) FullBackup time: 09/15/2010 14:30:09 IncBackup: (0x0,0,0) IncBackup time: 00/00/1900 00:00:00 Signature: Create time:10/18/2009 14:25:29 Rand:4524038 Computer: Env (CircLog,Session,Opentbl,VerPage,Cursors,LogBufs,LogFile,Buffers) ( off, 552, 27600, 15960, 27600, 2048, 2048, 25801) Operation completed successfully in 0.172 seconds. The hex number on the full backup line is the last log file that was included in the last full backup. The hex number on the checkpoint line is the log file of the last commited flush to the database. Regards, Michael B. Smith Consultant and Exchange MVP http://TheEssentialExchange.com From: Kleciak, Clint D A7IT [mailto:clint.klec...@cigna.com] Sent: Tuesday, September 28, 2010 3:58 PM To: MS-Exchange Admin Issues Subject: Number of Log files played into a database Besides counting the log files. Is there any script or powershell command that can tell me how many logs have been played into a database since the last backup? Thanks,,,,,CdK _______________________________________ Clint Kleciak --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to listmana...@lyris.sunbeltsoftware.com<mailto:listmana...@lyris.sunbeltsoftware.com> with the body: unsubscribe exchangelist ------------------------------------------------------------------------------ CONFIDENTIALITY NOTICE: If you have received this email in error, please immediately notify the sender by e-mail at the address shown. This email transmission may contain confidential information. This information is intended only for the use of the individual(s) or entity to whom it is intended even if addressed incorrectly. Please delete it from your files if you are not the intended recipient. Thank you for your compliance. Copyright 2010 CIGNA ============================================================================== --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to listmana...@lyris.sunbeltsoftware.com<mailto:listmana...@lyris.sunbeltsoftware.com> with the body: unsubscribe exchangelist ************************************************************************************************** Note: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. ************************************************************************************************** --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to listmana...@lyris.sunbeltsoftware.com<mailto:listmana...@lyris.sunbeltsoftware.com> with the body: unsubscribe exchangelist --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to listmana...@lyris.sunbeltsoftware.com<mailto:listmana...@lyris.sunbeltsoftware.com> with the body: unsubscribe exchangelist ************************************************************************************************** Note: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. ************************************************************************************************** --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to listmana...@lyris.sunbeltsoftware.com with the body: unsubscribe exchangelist
