Solved

Mirroring

Posted on 2011-03-08
6
461 Views
Last Modified: 2012-08-13
Hei!


  i am getting en error...

MSSSPI-3086.1: Size of unrestored log in the redo queue on the mirror database <$OPTION(database_name)> is 379.00 too high (>=95.00) for hswdbp01.  [Policy: DBSPI-3086]

//SHANJ
0
Comment
Question by:shanj
  • 3
  • 3
6 Comments
 
LVL 6

Expert Comment

by:MuffyBunny
ID: 35070114
You need to go to the send queue of the primary server and remove the log
0
 
LVL 6

Expert Comment

by:MuffyBunny
ID: 35070134
You should also adjust the size settings for the log so this doesn't happen again. Set it to a smaller value.
0
 

Author Comment

by:shanj
ID: 35071233
where do i find the send queue of the primary log?

and how do i adjust the size settings?

shan
0
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 
LVL 6

Expert Comment

by:MuffyBunny
ID: 35071417
In management studio, connect to your primary server (not the mirror), and right-click on it.

Under tasks, choose Launch Database Mirroring Monitor

Within this interface, you should be able to do everything necessary.
0
 

Accepted Solution

by:
shanj earned 0 total points
ID: 35080048
Hello !
      Launch Database mirroring monitor says nothing about the logs,
some fields feks: Unsent log:......current send rate..?  etc...etc
did not see where i can do the changes?
0
 

Author Closing Comment

by:shanj
ID: 35170971
sorry, did not solvee my problem
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

706 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now