Go Premium for a chance to win a PS4. Enter to Win



Posted on 2011-03-09
Medium Priority
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
  • 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Integration Management Part 2
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

877 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