Mirroring

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
shanjAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
shanjConnect With a Mentor Author Commented:
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
 
MuffyBunnyCommented:
You need to go to the send queue of the primary server and remove the log
0
 
MuffyBunnyCommented:
You should also adjust the size settings for the log so this doesn't happen again. Set it to a smaller value.
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
shanjAuthor Commented:
where do i find the send queue of the primary log?

and how do i adjust the size settings?

shan
0
 
MuffyBunnyCommented:
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
 
shanjAuthor Commented:
sorry, did not solvee my problem
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.