Posted on 2011-03-09
Last Modified: 2012-05-11
   getting this error many time a day, on a few servers..
"09:00MSSSPI-3086.1: Size of unrestored log in the redo queue on the mirror database <$OPTION(database_name)> is 371.00 too high (>=95.00) for hswdbp01.  [Policy: DBSPI-3086]"

Tried to go in task,launch mirror activities, but just could not find any help

anyone out their ....
Question by:shanj
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
  • 3
  • 2
LVL 40

Expert Comment

ID: 35096308

"Unrestored log threshold (set up at the mirror server): helps estimate how long it would take the mirror server to roll forward the log records remaining in its redo queue. We send an alert if the redo queue exceeds a certain threshold, usually between 250 kilobytes (KB) and 500 KB. The actual value may change for each database depending upon the database's workload and behavior patterns.
We run an initial script on the mirror that looks for any databases participating in database mirroring. It sets a baseline log threshold value for each database. Each mirrored database gets the same initial setting.
We run a second script on the mirror server that adjusts the threshold value for any databases that may need a different value due to differing patterns of update activity."

You should be able to chnage the treshold that by using kb article below:


Author Comment

ID: 35106269
Hi Icohan!
     the information u sent to me is just perfect.
I went thru it a few times but ....
I still am not getting it.

1. I launch the databasemirroring, on the plane warnings, no threshold i set up ( not enabled)

Thus i do not know what i should add their, ..?? any suggestions

appreciate your email.

PS: the 2 articles u sent me explains a lot, but i do not know where the threshold value is set up, and futher more how much should i change it to...
LVL 40

Expert Comment

ID: 35109351
Use sp_dbmmonitorhelpalert database_name to see the existing values of the trheshold alert(s)

Then use sp_dbmmonitorchangealert database_name  to set new values for an existing alert(s)


Accepted Solution

shanj earned 0 total points
ID: 35131109
Thanks for your info.

But again, i have done what the document says, but i get NULL and NULL  at the threshold is enabled or no.
bye for your kind patience

Author Closing Comment

ID: 35170967
The advise was excellent but it did not solve my problem, i have to look somewhere else, maybe hardware, dandwidth..etc..etc..

Featured Post

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

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

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

726 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