Event ID 9871 , pls give the solution we are getting warning msg every after maintenance (Network Steve Forum)

Event ID 9871 , pls give the solution we are getting warning msg every after maintenance

Hi, we did a migration from Domino to Exchange , we migrated Exchange 2007 it went successfully , but every after maintenance window we are getting the warning message below is the Warning message ,there is no Databases Backup window is running on Database Maintenance window, we have 4 data bases , in that first and Third are the mail databases..... Please help me on this  exchange Event Logs Name: Threshold: New Value: Previous Value: Application/MSExchangeIS Mailbox Store(9871) N/A Time: 9/30/2009 4:59:59 AM. Event description: There is an online maintenance overlap for database "Third Storage Group\Third SGDB". Please revise the online maintenance schedule. None Test Started: 9/30/2009 5:17:50 AM Test Finished: 9/30/2009 5:18:24 AM Please do the needfull........ Gopi

September 30th, 2009 12:51pm

Looks like your Backup Window and online maintenance time frame are Overlapping with each other. You need to configure your online maintenance other than your backup window Follow the below article to change the timings Exchange 2007 Online Maintenance Database Scanning (Part 1) http://www.msexchange.org/articles-tutorials/exchange-server-2007/monitoring-operations/exchange-online-database-scanning-part1.html Vinod |CCNA|MCSE 2003 +Messaging|MCTS|ITIL V3|

Free Windows Admin Tool Kit Click here and download it now

September 30th, 2009 1:09pm

Vinod , We check that , there is no Backup window while Maintenance window running , we have 4 hrs maintenance window running on that there is no backup window is running , is there any other i need to check , all Database maintenance window is running at time . is that causes, pls help me on this . Thanks, Gopi

September 30th, 2009 1:43pm

It is really not necessary until something is interfering with its schedule. also make sure AV scanning is not bothering the online maintenance Online Maintenance is part and parcel of maintaining a healthy database for your Exchange environment. In addition to performing online defragmentation, online maintenance performs other essential tasks such as permanently removing deleted items. For more information on what happens during online maintenance, check out JeremyK's weblog here: http://blogs.msdn.com/jeremyk/archive/2004/06/12/154283.aspx Because the online maintenance duration is directly proportional to the size of an Exchange database, it is entirely possible that defragmentation of a database cannot complete within a single day and may take several passes to complete. Look out for the event 703 for online defragmentation completed. With the above points in mind, you should run maintenance on each database every night. What you should be sensitive to are the following factors: 1. Server activity and peak hours - online maintenance during periods of high utilization will result in resource contention and overall degradation of end-user experience. 2. Backup durations - never schedule maintenance during a backup operation. In Exchange Server 2007, MS recommends using incremental backups in conjunction with high availability solutions such as continuous replication, which greatly reduces backup durations.Vinod |CCNA|MCSE 2003 +Messaging|MCTS|ITIL V3|

Free Windows Admin Tool Kit Click here and download it now

September 30th, 2009 1:51pm

Vinod thanks for Helping , iam wondering after Exchange migration, we didn't setup any maintenance for all databases manually but i can see the schedule window in properties of db schedule at 1AM to 5AM at the end of the window we will get warning 9871 , we didn't setup the maintenance manually it came default , is it we need to setup maintenance manually like the process which you gave in first replay in that link i can see the Maintenance process which Author Neil Hobson gave the process for online maintenance for databases. Vinod can you please tell me the process and setup for online maintenance to all Databases is it only we need to change the schedule time in db properties tab or we need to edit registry also....

September 30th, 2009 3:03pm

Free Windows Admin Tool Kit Click here and download it now

September 30th, 2009 3:13pm

Vinod , Can you please explain , can you please tell me how to do the online maintenance process , please help me on this , because iam little bit confuse that after migration the maintenance will configure defaultly or we need to do manually and are we need to edit the registry settings also.

September 30th, 2009 3:54pm

On Wed, 30-Sep-09 12:54:25 GMT, GopiChand418 wrote:>Vinod , Can you please explain , can you please tell me how to do the online maintenance process , please help me on this , because iam little bit confuse that after migration the maintenance will configure defaultly or we need to do manually and are we need to edit the registry settings also. Set the maintenance schedule to run from 01:00 to 04:45 for thatdatabase (or 00:45 to 04:45 if you really need four hours).Alternatively, start your backup at 05:01 instead of 05:00.---Rich MatheisenMCSE+I, Exchange MVP--- Rich Matheisen MCSE+I, Exchange MVP

Free Windows Admin Tool Kit Click here and download it now

October 1st, 2009 4:33am

Rich, Thanks for Help For Database maintenance setup option i can see in DB right click properties their i can see the window to schedule , is that the only setup or i need to do some moreprocess for online db maintenance, we are at starting stage we migrated only few users , can you pleasetell me how long does the maintenance requires and which time is better to schedule the maintenance our Exchange complete DB backup takes max 20min and Backup completes before 8pm, and they have never interfered with the 1am - 5am maintenance window we have currently. and aim not able to do the maintenance set up exact till 04:45 , aim able to do till 4 or 5 Please tell me the process how to schedule the maintenance window and how long it requires will be make sure that no backups are running on that time .

October 1st, 2009 3:27pm

It depends upon the size of database. it is always better to configure when server is idle such as off hours and also when backup is not running. Read under Setting the Online Maintenance Window http://www.simple-talk.com/sysadmin/exchange/monitoring-and-scheduling-exchange-2007-database-online-maintenance/ Vinod |CCNA|MCSE 2003 +Messaging|MCTS|ITIL V3|

Free Windows Admin Tool Kit Click here and download it now

October 1st, 2009 3:33pm

On Thu, 1-Oct-09 12:27:06 GMT, GopiChand418 wrote:>Rich, Thanks for Help For Database maintenance setup option i can see in DB right click properties their i can see the window to schedule , is that the only setup or i need to do some more process for online db maintenance, That's all. Select the "15 Minute" radio button to set times insmaller slices than whole hours.nance requires and which time is better to schedule the maintenance our Exchange complete DB backup takes max 20min and Backup completes before 8pm, and they have never interfered with the 1am - 5am maintenance window we have currently. and aim not able to do the maintenance set up exact till 04:45 , aim able to do till 4 or 5 Selecting the "15 Minute" radio button will allow you to deselect the15-minute slice just before 05:00.The application event log records the start and stop of eachcompaction pass. I'd guess that that you're probably running, in thatfour-hour window, 16 complete compaction passes. You could probablyjust run the maintenance task between 01:00 and 01:30 for now.As your database grows the time to complete an entire compaction passwill grow. You can adjust your schedule accordingly to accomodate thatgrowth.While the online compaction is an important operation, it isn'tnecessary that it completes every day. If it finishes a pass everybly good enough. If the database grows solarge that you can't complete a pass in less than several days,consider scheduling the maintenance task to run for a longer period onnon-work days (e.g. from 12:00 to 19:45 and 01:00 to 04:45 on Saturdayand Sunday).>Please tell me the process how to schedule the maintenance window and how long it requires will be make sure that no backups are running on that time . ---Rich MatheisenMCSE+I, Exchange MVP--- Rich Matheisen MCSE+I, Exchange MVP

October 2nd, 2009 6:22am

Rich, Thanks for update, currently our mail databases maintenance are scheduled default 1am to 5am are scheduled at same time for every databases , think by your replay we need to schedule in a diff window for every databases will do that n let u know how it went .... Rich can you please tell me is that online maintenance and online defragmention are same , as if now iam doing the online maintenance process , i didnt see any process how to do online defragmentation, is that the diff setup i need to do for online defragmentation , or online maintennace and online defragmentation are same. thnx, Gopi

Free Windows Admin Tool Kit Click here and download it now

October 4th, 2009 5:33pm

On Sun, 4-Oct-09 14:33:18 GMT, GopiChand418 wrote:> Thanks for update, currently our mail databases maintenance are scheduled default 1am to 5am are scheduled at same time for every databases , think by your replay we need to schedule in a diff window for every databases will do that n let u know how it went ....Staggering the scheduled maintenance tasks is a good idea. Not runningthem for longer than necessary is also a good idea. Theof I/O.> Rich can you please tell me is that online maintenance and online defragmention are same , as if now iam doing the online maintenance process , i didnt see any process how to do online defragmentation, is that the diff setup i need to do for online defragmentation , or online maintennace and online defragmentation are same.The online defragmentation is one of the scheduled maintenance tasks.---Rich MatheisenMCSE+I, Exchange MVP--- Rich Matheisen MCSE+I, Exchange MVP

October 4th, 2009 6:39pm

On Sun, 4-Oct-09 14:33:18 GMT, GopiChand418 wrote: Staggering the scheduled maintenance tasks is a good idea. Not running them for longer than necessary is also a good idea. The of I/O. Could you clarify this a bit? Or do you mean, if you are using SAN, then the maintenance which is not needed generate unnecessarily load to the SAN? -- Petri

Free Windows Admin Tool Kit Click here and download it now

October 4th, 2009 9:23pm

Hi, Still we are seeing the warning message from Exchange Event ID 9871, there is no backup window is running while maintenance window is running but still we are seeing this warning , we scheduled a diff maintenance window for every database given a gap 3min , First storage group we schedule maintenance at 1am to 2:30am Third storage group er schedule maintenance at 3am to 4:30am We got warning after every end of the maintenance window. we are using SAN storage. please help me on this ...

October 7th, 2009 12:09pm

Have you tried update rollups or SP2? If you disable maintenance to run on one database only, do you still see the warning? -- Petri

Free Windows Admin Tool Kit Click here and download it now

October 7th, 2009 4:22pm

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4  /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} Here’s the output from the power shell script , the maintenance window is running every day and has a gap for First storage and Third storage mailbox and at the end of the maintenance window we are getting the warring massage Name : First SGDB Identity : exchange\First Storage Group\First SGDB EdbFilePath : E:\Program Files\Microsoft\Exchange Server\Mailbox\First St orage Group\First SGDB.edb DefragStart : 10/5/2009 1:20:15 AM DefragEnd : 10/6/2009 3:21:33 AM DefragDuration : 17290 DefragInvocations : 2 DefragDays : 1 Name : Fourth SGDB Identity : exchange\Fourth Storage Group\Fourth SGDB EdbFilePath : F:\Program Files\Microsoft\Exchange Server\Mailbox\Fourth S torage Group\Fourth SGDB.edb DefragStart : 10/7/2009 4:00:00 AM DefragEnd : 10/7/2009 4:00:00 AM DefragDuration : 0 DefragInvocations : 1 DefragDays : 1 Name : Third SGDB Identity : exchange\Third Storage Group\Third SGDB EdbFilePath : G:\Program Files\Microsoft\Exchange Server\Mailbox\Third St orage Group\Third SGDB.edb DefragStart : 10/3/2009 2:59:25 AM DefragEnd : 10/6/2009 1:02:16 AM DefragDuration : 29832 DefragInvocations : 4 DefragDays : 2 Name : Public Folder Database Identity : exchange\Second Storage Group\Public Folder Database EdbFilePath : D:\Program Files\Microsoft\Exchange Server\Mailbox\Second S torage Group\Public Folder Database.edb DefragStart : 10/7/2009 4:00:01 AM DefragEnd : 10/7/2009 4:00:01 AM DefragDuration : 0 DefragInvocations : 1 DefragDays : 1

October 7th, 2009 5:13pm

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4  /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} Here’s the output from the power shell script , for every database like First and Third Storage DB we have a diff window schedule for maintenance and it runs every day , so every day at the end of the Maintenance window we are getting the warning , please suggest how we resolve this warning or can we schedule for once in 2 weeks on off hours , please check the the below script we got from power shell . Name : First SGDB Identity : exchange\First Storage Group\First SGDB EdbFilePath : E:\Program Files\Microsoft\Exchange Server\Mailbox\First St orage Group\First SGDB.edb DefragStart : 10/5/2009 1:20:15 AM DefragEnd : 10/6/2009 3:21:33 AM DefragDuration : 17290 DefragInvocations : 2 DefragDays : 1 Name : Fourth SGDB Identity : exchange\Fourth Storage Group\Fourth SGDB EdbFilePath : F:\Program Files\Microsoft\Exchange Server\Mailbox\Fourth S torage Group\Fourth SGDB.edb DefragStart : 10/7/2009 4:00:00 AM DefragEnd : 10/7/2009 4:00:00 AM DefragDuration : 0 DefragInvocations : 1 DefragDays : 1 Name : Third SGDB Identity : exchange\Third Storage Group\Third SGDB EdbFilePath : G:\Program Files\Microsoft\Exchange Server\Mailbox\Third St orage Group\Third SGDB.edb DefragStart : 10/3/2009 2:59:25 AM DefragEnd : 10/6/2009 1:02:16 AM DefragDuration : 29832 DefragInvocations : 4 DefragDays : 2 Name : Public Folder Database Identity : exchange\Second Storage Group\Public Folder Database EdbFilePath : D:\Program Files\Microsoft\Exchange Server\Mailbox\Second S torage Group\Public Folder Database.edb DefragStart : 10/7/2009 4:00:01 AM DefragEnd : 10/7/2009 4:00:01 AM DefragDuration : 0 DefragInvocations : 1 DefragDays : 1

Free Windows Admin Tool Kit Click here and download it now

October 7th, 2009 5:22pm

That looks a bit strange, why first database is running Defrag about 24 hours and third is running 72 hours. I believe there are some overlaps. If I understood correctly. If not, then could you send output for the cmd-let: Get-MailboxDatabase -server <type your server name> | fl Identity,maintenanceschedule -- Petri

October 7th, 2009 10:53pm

Petri, can you please tell the process to get the info you need ... i typed the below command in exchange server but it says | was unexcepted at this time think may be i typed a wrong in cmd can you please tell the clear command Get-MailboxDatabase -server <type your server name> | fl Identity,maintenanceschedul

Free Windows Admin Tool Kit Click here and download it now

October 8th, 2009 11:17am

On the management shell try at first: Get-MailboxDatabase -server <type your server name> e.g. Get-MailboxDatabase -server excsrv1 You should get your databases. Then try the whole command: Get-MailboxDatabase -server <type your server name> | fl Identity,maintenanceschedule e.g. Get-MailboxDatabase -server excsrv1 | fl Identity,maintenanceschedule "|" is the "pipe", like you can do: dir /s | more -- Petri

October 8th, 2009 12:44pm

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4  /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} Identity : exchange\Fourth Storage Group\Fourth SGDB MaintenanceSchedule : {Sun.1:00 AM-Sun.5:00 AM, Mon.1:00 AM-Mon.5:00 AM, Tue.1: 00 AM-Tue.5:00 AM, Wed.1:00 AM-Wed.5:00 AM, Thu.1:00 AM-T hu.5:00 AM, Fri.1:00 AM-Fri.5:00 AM, Sat.1:00 AM-Sat.5:00 AM} Identity : exchange\Third Storage Group\Third SGDB MaintenanceSchedule : {Sun.3:00 AM-Sun.4:45 AM, Mon.3:00 AM-Mon.4:45 AM, Tue.3: 00 AM-Tue.4:45 AM, Wed.3:00 AM-Wed.4:45 AM, Thu.3:00 AM-T hu.4:45 AM, Fri.3:00 AM-Fri.4:45 AM, Sat.3:00 AM-Sat.4:45 AM} Identity : exchange\First Storage Group\First SGDB MaintenanceSchedule : {Sun.1:00 AM-Sun.2:45 AM, Mon.1:00 AM-Mon.2:45 AM, Tue.1: 00 AM-Tue.2:45 AM, Wed.1:00 AM-Wed.2:45 AM, Thu.1:00 AM-T hu.2:45 AM, Fri.1:00 AM-Fri.2:45 AM, Sat.1:00 AM-Sat.2:45 AM}

Free Windows Admin Tool Kit Click here and download it now

October 8th, 2009 3:40pm

Hey, I think the answer to you issue is this thread . It make sense that it can be safely ignored because sometime even when your maintenance window is closed, some process might still be running. e.g. your online defragmentation So this warning is logged. Thanks. Vishal Ramnani | MCITP - Exchange 2007 | MCSE Messaging | MCTS - Win 2008 Config

October 9th, 2009 2:23pm

This topic is archived. No further replies will be accepted.