Hi I can't seem to get my head around something :)We are using Exchange 2007 SP1 and Netbackup. Although for this question it could be any Backup software (.e.g BackupExec, Legato etc)Let's say I have a database - DB1.At 22:00, the backup job starts. This job will backup the DB1 EDB file and also the transaction logs.Question1: When the backup job runs, does the act of running the backup job flush the logs? Or does the backup data actually contain the EDB file and the transaction logs that were generated since the last FULL backup. So, basically, should I expect to see log files in the backup?Question2: Once the backup job completes, I should still expect to see some logs, correct? Since the backup flushes only logs that have been COMMITTED to the db?<br /%

On Wed, 10 Mar 2010 12:47:30 +0000, Sheen1990 wrote:>>>Hi I can't seem to get my head around something :)We are using Exchange 2007 SP1 and Netbackup. Although for this question it could be any Backup software (.e.g BackupExec, Legato etc)Let's say I have a database - DB1.At 22:00, the backup job starts. This job will backup the DB1 EDB file and also the transaction logs.Question1: When the backup job runs, does the act of running the backup job flush the logs? No.>Or does the backup data actually contain the EDB file and the transaction logs that were generated since the last FULL backup. The completed backup will consist of the database file plus any logfiles that contain uncommitted transactions at the time the backupbegan and any log files generated during the backup.>So, basically, should I expect to see log files in the backup?Yes. They're necessary to replay the transactions into the database.>Question2: Once the backup job completes, That's correct.>I should still expect to see some logs, correct? Since the backup flushes only logs that have been COMMITTED to the db?The backup doesn't 'flush' log files. At the end of the backup thesystem attendant is instructed to remove the unnecessary log files.---Rich MatheisenMCSE+I, Exchange MVP--- Rich Matheisen MCSE+I, Exchange MVP

Hi, I think you should also make a test to find out the answer by yourself. 1,create a new storage group and database, create a new mailbox located in the database. 2,use eseutil /mk to check which log file the check point file point to . 3,make a full backup using ntbackup 4,go to log file to check which logs are removed. 5,restore the database using ntbackup, choose the location of temp log files,don't choose the "last restore set". 6, go to temp log files directory, you can find the uncommitted transaction logs on there.Frank Wang