Re: HA for SMS Database

From what I know at this point (as the "SQL Stuff" writer for Configuration
Manager 2007 (aka SMSv4)) is that database mirroring will not be supported
in Configuration Manager 2007. Hosting the site database on a virutal SQL
Server cluster instance will be, but not the mirroring part. So cluster=yes,
mirroring=no at this point.

Of course, Configuration Manager 2007 hasn't shipped yet, so this is just
how the support stands right now and may change.

--
Jeff Gilbert, MCSE
Technical Writer | Windows & Enterprise Management Division
Microsoft Corporation

This posting is provided "AS IS" with no warranties and confers no rights.

"Kim Oppalfens <MVP>" <Kim dot Oppalfens@google mail.com> wrote in message
news:B195D549-5B86-4067-BE51-CCC44DFC0C37@xxxxxxxxxxxxxxxx
Yups, someone know. More specifically the faq knows.
And the answer is no, sms does not support it, and it will not work.
SCCM 2007 aka sms v4 which is due next summer will support database
mirroring.

--
"Everyone is an expert at something"
Kim Oppalfens - Sms Expert for lack of any other expertise
Windows Server System SMS - MVP


"spcqky" <spcqky@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0822EA4D-534E-45BB-A9FC-25FC90D4619F@xxxxxxxxxxxxxxxx
Hi,
What is the recommendation to achieve the above (HA is deemed crucial)?

Does anyone know if SMS 2003 SP2 or SCCM 2007 support database mirroring
available with SQL 2005 SP1?

Kindly advise.

Thanks

spencer



.

Loading