Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Mirroring

Posted on 2011-03-08
6
Medium Priority
?
471 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
[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
  • 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
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
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

New benefit for Premium Members - Upgrade now!

Ready to get started with anonymous questions today? It's easy! Learn more.

Question has a verified solution.

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

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
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…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

722 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