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 2005 Forums
 High Availability (2005)
 SQL 2005 standard edition mirroring

Author  Topic 

dilpz213
Starting Member

2 Posts

Posted - 2009-09-08 : 07:02:52
Hi,

Im looking into using database mirroring with SQL 2005 standard edition as an alternative to clustering. I was wondering whether anyone could tell me if the automatic failover option is available with SQL 2005 standard edition using a witness server or is this option only available with enterprise edition?

If anyone can answer this please let me know.

Thanks

SreenivasBora
Posting Yak Master

164 Posts

Posted - 2009-09-23 : 08:54:52
Yes Automatic FO is available on SQL 2005 Standard/Developer/EE editions with SAFETY = FULL

With Regards
BSR
Go to Top of Page

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2009-09-23 : 09:58:46
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx?PHPSESSID=0324345d45ef1bf1f764044e03584cd0

- Lumbago
Go to Top of Page
   

- Advertisement -