Solved

Mirroring

Posted on 2011-03-08
6
465 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

840 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