Solved

Backup Exec 2010 and Exchange 2007: Database logs not flushed for one Storage Group

Posted on 2016-07-25
7
59 Views
Last Modified: 2016-08-01
There are two storage groups backup up by Backup Exec. They are set up as separate jobs.
Both have logged successful completions but on one of them, Exchange is not deleting the old logs.
On Exchange I checked:

1. With Powershell:
get-mailbox database -server 'server' -status | format-table name,storagegroup,lastfullbackup

Open in new window

This shows the last full backup time is 7/24/2016, same as reported by Backup Exec

2.  With cmd:
vssadmin list writers

Open in new window

This shows no errors with any of the writers. All are in State [1] Stable except for 'Microsoft Exchange Writer' and 'Shadow Copy Optimization Write' which are in State [5] Waiting for completion.
There is a backup for the problematic Storage group running now (after I made the changes listed below in the Backup Exec description), so I think this is normal. Please correct me if it is not.

3. Event Viewer shows ID 9827 logged after every successful backup.
Interestingly, I do not see it logged for the Storage Group in which the logs are being flushed.

Backup Exec Settings

I compared the settings set with the other job that is working properly. Everything looked proper except for the #2 and #3.

1. Full - Database & Logs (flush committed logs) - This was already set
2. Verify after backup completes: Yes changed from 'No'
3. Let Backup Exec automatically choose the best copy to back up (recommended) changed from 'Backup from Active Copy only'

I am running the backup job again after changing the "High Availability Settings" to the recommended value.
Is it possible that  backing up from the Active database and not verifying after completion is the cause of the logs not being flushed?
What other logs should I check to see if the problem lies elsewhere?
0
Comment
Question by:SeeDk
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
7 Comments
 
LVL 32

Expert Comment

by:Rodney Barnhardt
ID: 41728751
is the database where the logs are not flushing small, with very little change each day? If you look at the logs, do they eventually flush or commit older ones like 5-7 days back? If so, this is normal. I had a case opened with MS a few years ago. There is a minimum log size or change before they commit. He sent me a KB to explain it. I will see if I can locate it if that is the case.
0
 

Author Comment

by:SeeDk
ID: 41728985
They haven't flushed since April.
I looked into this  more and see it could be a problem with SCR.
When I check
get-storagecopystatus -standybymachine

Open in new window

on the Exchange server

I see the status for this Storage Group is Suspended and the CopyQueueLength is 1379183.
There is also an ESE event in Event Viewer:
Event ID 225 the log files cannot be truncated.

In ADSI Edit, if I look under CN=Configuration\CN=Services\CN=Microsoft Exchange\CN=<org name>\CN=Administrative Groups\CN=Exchange Administrative Group (FYDIBOHF23SPDLT)\CN=Servers\CN=<Servername>\CN=InformationStore\CN=<Storage Group Name>
 
Scroll down to the attribute msExchStandbyCopyMachines...the passive node is listed there.

The strange thing is the other Storage Group shows the CopyStatus as  NotConfigured but when I check the passive node, I can see its database is being copied there.
But when I check ADSI edit, the attribute msExchStandbyCopyMachines is empty for this Group as well.

Is this a bug with SCR or is this expected output? Would un-suspending this Storage Group resolve the problem?
0
 
LVL 30

Expert Comment

by:Sudeep Sharma
ID: 41729287
It seems like the bug with SBE 2010.

Did you tried creating a new job, new backup location for the Exchange and tried full backup with log truncation?

Sudeep
0
Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

 

Author Comment

by:SeeDk
ID: 41729385
Thanks Sudeep, I may try that next before changing anything on the Exchange side.
However, is this known to be a bug with the backup software...I thought log deletion was done on the Exchange side?
Does SCR being suspended mean Exchange will not delete the log files?

I thought this is how the deletion process works:

1. Backup software completes backup successfully.
2. Backup software tells Exchange the backup was successful.
3. Exchange then deletes log files.

Is this correct or am I misinformed?
These are the events logged when a backup is finished which seem to show Exchange is notified of a successful backup.

1. Event 9827 MS ExchangeIS
Exchange VSS Writer (instance 5e6786ec-f740-486c-bd25-02d17a0e5291:219) has successfully completed the full or incremental backup of replicated storage group 'First Storage Group'. The log files will be truncated after they have been replayed.

2.  Event 225 ESE
MSExchangeIS (2076) First Storage Group: No log files can be truncated.  

3.  Event 2006 ESE
Information Store (2076) Shadow copy instance 219 completed successfully.

3. Event 9616 MSExchangeIS
Exchange VSS Writer (instance 5e6786ec-f740-486c-bd25-02d17a0e5291:219) has processed the backup completion event successfully.

4. Event 9648 MSExchangeIS
Exchange VSS Writer (instance 5e6786ec-f740-486c-bd25-02d17a0e5291:219)  has processed the backup shutdown event successfully.
0
 
LVL 30

Expert Comment

by:Sudeep Sharma
ID: 41729449
If you would like you could use Windows Backup (VSS FUll) and you would notice that the log truncation has completed successfully.

Thanks,
Sudeep
0
 

Accepted Solution

by:
SeeDk earned 0 total points
ID: 41731119
Well, I decided to try the Exchange route first and thankfully it worked.
It was SCR related after all.
After both disabling SCR and removing the passive node server entry in msExchStandbyCopyMachines using ADSI edit as explained in this post; I ran a full backup again and the logs were flushed once the backup completed.

Event Viewer also logged an Event 9780 which matches what was being logged for the other Storage Group which has been working fine:

Exchange VSS Writer (instance 3d4e98d5-5485-471c-8ca7-150c763ad243:223) has successfully completed the full or incremental backup of storage group 'First Storage Group'.

The database engine has also successfully executed log file truncation procedures for this storage group. (Note that this may or may not have resulted in the actual truncation of log files, depending on whether any log files existed that were candidates for truncation.)
0
 

Author Closing Comment

by:SeeDk
ID: 41737184
Found solution outside of EE.
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Learn to move / copy / export exchange contacts to iPhone without using any software. Also see the issues in configuration of exchange with iPhone to migrate contacts.
Microsoft will be releasing the Windows 10 Creators Update in just a matter of weeks. Are you prepared? Follow these steps to ensure everything goes smoothly and you don't lose valuable data on your PC.
This tutorial will walk an individual through the process of configuring basic necessities in order to use the 2010 version of Data Protection Manager. These include storage, agents, and protection jobs. Launch Data Protection Manager from the deskt…
This video demonstrates how to sync Microsoft Exchange Public Folders with smartphones using CodeTwo Exchange Sync and Exchange ActiveSync. To learn more about CodeTwo Exchange Sync and download the free trial, go to: http://www.codetwo.com/excha…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question