Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

database Mirroring with suspend ?? Expand / Collapse
Author
Message
Posted Thursday, December 27, 2012 2:53 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Saturday, September 6, 2014 10:51 AM
Points: 204, Visits: 766
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

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, March 21, 2014 9:46 AM
Points: 387, Visits: 1,078
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
Posted Thursday, December 27, 2012 4:57 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Saturday, September 6, 2014 10:51 AM
Points: 204, Visits: 766
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

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, March 21, 2014 9:46 AM
Points: 387, Visits: 1,078
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
Posted Friday, December 28, 2012 3:04 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Saturday, September 6, 2014 10:51 AM
Points: 204, Visits: 766
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

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, March 21, 2014 9:46 AM
Points: 387, Visits: 1,078
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
Posted Friday, December 28, 2012 6:36 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Saturday, September 6, 2014 10:51 AM
Points: 204, Visits: 766

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 »

Add to briefcase

Permissions Expand / Collapse