> OK, folks, this is gonna be a weird question (ok, pretty geeky), BUT:

My name is Justin and I am a geek.

> Can I somehow mirror an SQL/CF server to another server?

Yes.

> Don't know if it matters but they are in the same building...I want
> to make the 2nd one redundant so that it reads/writes what is happening
> on the primary but can be brought online immediately if the primary fails
> - kind of like  a PDC/BDC arrangement?  Is there special software I need?
>  Or can I do with  within the W 2k environment?

This is called "hot standby". Only  windows2000 Advanced server has this
built in.
SQL Server 2000 works with Windows NT and Windows 2000 failover clustering
to support immediate failover to a backup server in continuous operation.


> Also, I can get a PKI certificate for the 2nd one so that I can use https

Yes you can , you can but one cert of both  using Thawte, or 2 certs from
verisign
However whichever you choose the ssl session will be restarted id a session
started on one box ends up on the other box...


overall: you might want to think about this setup more. You will get better
performance using 1 box as a SQL server and the other as your Web/IIS/CF
box.

2 boxs * 98.x% uptime might be better than 1 x 99.x% uptime....

Its always a trade off...

Justin


-- 
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]

Reply via email to