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?
 
shanjAuthor 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
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
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.