Database Mirroring using SQL Server 2005

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Database Mirroring using SQL Server 2005

Database Mirroring using SQL Server 2005

Rate Topic

Display Mode

Topic Options

Author

Message

dakshinamurthy-655138

Posted Friday, April 03, 2009 6:34 AM

Old Hand

Group: General Forum Members
Last Login: Friday, June 14, 2013 8:27 AM
Points: 329, Visits: 890

Hi,

I have configured the Database Mirroring having principal , mirror and witness in 3 different servers which is in the same network and domain. My configuration of Database Mirroring using SQL Server 2005 was successfull, but the auto failover from principal to mirror is not happening once i stop the sql server for 5 mins.

Earlier i had set up the same scenario using the same stepts, it was working and auto failover was happening if i stop the sql server agent of the principal, now its not happening.

All the 3 servers, principal, mirror and witness has same login and pwd for the system, and the DB also has the same login [sa] and pwd.

I was able to to Manual Failover and the data was in Synchronize, but the automatic failover is not happening. Pls help me.

I am not getting any error.

Please help me what need to be checked and why its not happening.

I need one more information, if my database is in disconnected mode and i am able to execute a query or SP using SSMS can i have the access to the same DB if this DB has been connected to an Application.

With Regards
Dakshina Murthy

Post #689796

Mohit K. Gupta

Posted Friday, April 03, 2009 11:20 AM

SSC Eights!

Group: General Forum Members
Last Login: Monday, June 10, 2013 10:58 AM
Points: 941, Visits: 1,042

Few things to check if automatic failover is not taking place:

1) Both servers can see witness.
2) Your mirroring is set to automatic failover.

SELECT *
FROM sys.database_mirroring

Columns of interest: mirroring_witness_state_desc, mirroring_safety_level_desc

Thanks.

Mohit.

---

Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN.
Microsoft FTE - SQL Server PFE

* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. Smooooth

How to ask for help .. Read Best Practices here.

Post #690096

« Prev Topic | Next Topic »

Permissions