database Mirroring with suspend ??

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » database Mirroring with suspend ??

database Mirroring with suspend ??

Rate Topic

Display Mode

Topic Options

Author

Message

Lavanyasri

Posted Thursday, December 27, 2012 2:53 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, March 05, 2013 5:58 AM
Points: 199, Visits: 741

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

Post #1400523

Posted Thursday, December 27, 2012 3:12 AM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 3:36 AM
Points: 305, Visits: 493

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.

Post #1400534

Lavanyasri

Posted Thursday, December 27, 2012 4:57 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, March 05, 2013 5:58 AM
Points: 199, Visits: 741

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

Post #1400563

Posted Thursday, December 27, 2012 10:29 PM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 3:36 AM
Points: 305, Visits: 493

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?

Post #1400791

Lavanyasri

Posted Friday, December 28, 2012 3:04 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, March 05, 2013 5:58 AM
Points: 199, Visits: 741

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.

Post #1400846

Posted Friday, December 28, 2012 3:48 AM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 3:36 AM
Points: 305, Visits: 493

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?

Post #1400859

Lavanyasri

Posted Friday, December 28, 2012 6:36 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, March 05, 2013 5:58 AM
Points: 199, Visits: 741

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

Post #1400890

« Prev Topic | Next Topic »

Permissions