SQLServer Principal System failure detection

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

High Availability (2008)

SQLServer Principal System failure detection

Author

Topic

naren514
Starting Member

5 Posts

Posted - 2012-01-27 : 12:11:38

In SQL Server Mirroring, When a principal system is Shut down,the another system(Mirror System) is not acting as a principal system,when we request a connection to that SQL Server the connection cannot be established.
But when we failover the Principal Mirror manually by clicking on failover button, its working fine.
I need the idea to detect the failure of the Principal system.
or
when the principal gets turned off,the mirror system should act as Principal.
Plz help me.

Thanks,
Narender.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2012-01-27 : 12:15:52

Do you have a witness server?

--
Gail Shaw
SQL Server MVP

naren514
Starting Member

5 Posts

Posted - 2012-01-28 : 04:41:15

No we dont have a witness server.

quote:
Originally posted by GilaMonster

Do you have a witness server?

--
Gail Shaw
SQL Server MVP

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2012-01-28 : 05:01:57

You need a witness server for automatic failover. Without a witness, you're limited to manual failover only.

--
Gail Shaw
SQL Server MVP

naren514
Starting Member

5 Posts

Posted - 2012-01-28 : 06:53:37

ok.. thanks a lot.

quote:
Originally posted by GilaMonster

You need a witness server for automatic failover. Without a witness, you're limited to manual failover only.

--
Gail Shaw
SQL Server MVP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources