SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


database Mirroring with suspend ??


database Mirroring with suspend ??

Author
Message
Lavanyasri
Lavanyasri
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1931 Visits: 966
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
SQL Show
SQL Show
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2809 Visits: 1078
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
Lavanyasri
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1931 Visits: 966
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
SQL Show
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2809 Visits: 1078
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
Lavanyasri
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1931 Visits: 966
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
SQL Show
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2809 Visits: 1078
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
Lavanyasri
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1931 Visits: 966
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
submani
SSC Rookie
SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)

Group: General Forum Members
Points: 33 Visits: 2
I followed this setps and problem Solved.

open new query:

Alter database DBNAME set partner resume


Done


Thanks,
Mani
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search