1

The instructor got me confused on this one:

Exchange transaction logs get committed during full/normal backup. Incremental and differential backups only backup the logs. OK that is clear. But he also mentioned that the frequency of the committment is depending on the database size.

If the second is true than the logs get committed not only on full/normal backups, that means that the archive bit on EDB and STM files should be set, as they have changed. Than why are EDB and STM files not backed up in differential and incremental backups, they both use the archive bit don't they?

Greg Askew
  • 34,339
  • 3
  • 52
  • 81
Dean
  • 979
  • 3
  • 9
  • 19

2 Answers2

3

This link from Microsoft explains a bit about transaction logs in Exchange 2003.

You are talking about 2 different things that are confusing you I think. The archive bit just tracks changed files during an external backup of the filesystem. Committed transactions are for the Exchange database to reference in the event of an unexpected shutdown. Transactions are first written to the transaction log and then committed to the Exchange database. The checkpoint file keeps track of which transaction logs have been committed to the Exchange database so if you had to to a restore of Exchange, it would know which transactions it has to restore from the transaction logs and which are already committed to the database.

This link explains a bit about the Exchange Backup procedures. Performing a full backup physically clears the transaction log files from disk among other things, but is unrelated to the archive bit on the physical transaction logs. Here is an excerpt from the link:

The high-level interaction between the VSS, the Exchange writer, and Exchange Server 2003 during backup or restore operations is as follows:

1. The backup program (or agent) runs a scheduled job.
2. The VSS requestor in the backup/restore application sends a command to the VSS to take a shadow copy of the selected Exchange Server 2003 storage groups.
3. The VSS communicates with the Exchange writer to prepare for a snapshot backup. Exchange Server 2003 prohibits administrative actions against the storage group, checks volume dependencies, and suspends all write operations to database and transaction log files while allowing read-only access.
4. The VSS communicates with the appropriate storage provider to create a shadow copy of the storage volume that contains the Exchange Server 2003 storage group.
5. The VSS releases Exchange Server 2003 to resume ordinary operations.
6. The VSS requestor verifies the integrity of the backup set prior to signaling the backup was successful. Exchange Server 2003 truncates the transaction logs and records the time of the last backup for the database.

Here's one more link explaining the Exchange database and how transactions are processed.

You will probably get more out of reading the info in the links than you will trying to follow my horrible, convoluted explanation :)

August
  • 3,114
  • 15
  • 17
1

Exchange (and SQL Server internal=) backup are not relying on the archive bit at all, which is a reminder for external backup tools.

They manage backups on a LOT more detailed level than that internally.

TomTom
  • 50,857
  • 7
  • 52
  • 134
  • Internal backup tools? What about Windows 2003 Backup Utillity? It isn't considered internal Exchange backup tool. – Dean Jun 15 '12 at 19:13
  • 1
    It is - but because it integrates, it does not use the primitive dos time flags. It CALLS exchange, because when you isntall exchange exchange installs a plugin into the backup tool. – TomTom Jun 15 '12 at 20:54