database Mirroring with suspend ??

Question

database Mirroring with suspend ??

Lavanyasri

SSCarpal Tunnel

Points: 4907
More actions
December 27, 2012 at 2:53 am

#266639

Hi team,
we configured dataabase mirroing with in the cluster . Now one of the database in suspend mode . configured mirroing on High protection mode .
Database (principal,suspend)
Can you please suggest how resolve this issue.
Thanks,
Lavanya

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

SQL Show SSCertifiable Points: 6143 More actions · Answer 1

Is it due to planned activity or because of any errors?. If not planned activity, you need to check sql log for more information which caused suspended mirroring sessions.

Did you try to run (in principal) ALTER DATABASE Yourmirroringdatabsename set partner resume.

Lavanyasri SSCarpal Tunnel Points: 4907 More actions · Answer 2

hi ,

I got the below error message from the log

Message

, the remote mirroring partner

for database XXXXXXXXX, encountered error 1204, status 4, severity 19.

Database mirroring has been suspended. Resolve the error on the remote server and resume mirroring,

or remove mirroring and re-establish the mirror server instance.

thanks,

Lavanya

SQL Show SSCertifiable Points: 6143 More actions · Answer 3

Mirrored server might be inaccessbile at that time. It could be network or some other issue in partner.You need to check your mirrord server's error log and event viewer as well for more information and post them here.

Do you have mirrore suspended occasionally or with a same time pattern?

Lavanyasri SSCarpal Tunnel Points: 4907 More actions · Answer 4

Thanks for the response

I got the below error from mirror at the same time from sql error log :

Error: 1204, Severity: 19, State: 4.

The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time. Rerun your statement when there are fewer active users. Ask the database administrator to check the lock and memory configuration for this instance, or to check for long-running transactions.

Error: 1454, Severity: 16, State: 1.

Database mirroring will be suspended.

Server instance 'XXXXXXXXX' encountered error 1204, state 4, severity 19

when it was acting as a mirroring partner for database 'XXXXXXXXX'.

The database mirroring partners might try to recover automatically from the error and resume the mirroring session.

For more information, view the error log for additional error messages.

SQL Show SSCertifiable Points: 6143 More actions · Answer 5

SQL Show (12/27/2012)
Do you have mirrore suspended occasionally or with a same time pattern?

???

Mirrored server seems running out of memory which could force it to be unavailable to principal.

As per your error messge, its clear you need to tune your mirrored server's memory usage.

Do your Principal and Mirror have same configuration?

Lavanyasri SSCarpal Tunnel Points: 4907 More actions · Answer 6

The issue was resolved by other team , but i dont know how to resolved this ??

Can you have any inputs how to resolve this issue?

in the principal server

1. Alter database mirrodatabasename set partner resume

or

2. take the log backup in principal and restore in the mirror database

the above two are my assumptions, i am not clear about that .

share your inputs

submani Valued Member Points: 59 More actions · Answer 7

I followed this setps and problem Solved.

open new query:

Alter database DBNAME set partner resume

Done

Thanks,

Mani