I'm looking for information about SQL2005's new featured called "Database
Mirroring". What do you know about it? How does it compare to existing
SQL2000 clustering/replication services? Will be only available to cluster
servers? (I mean... shared devices, mscs, etc).

Thanks

Download the beta and read BOL under data mirroring.

Clustering is largely a hardware functionality which requires Enterprise
Editions of SQL Server and the OS. Data Mirroring doesn't (works on Standard
and above - not on Workgroup) but does require a third server in the mix -
called a witness. Both support automatic failover.

Data Mirroring mirrors a database, with replication you can replicate a
subset of your database. With Data Mirroring the destination database is
read only or inaccessible to users, with replication this is not the case.

You can run data mirroring on your laptops - there is no hardware/software
requirements.


--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

"Jorge Martinez" <nospam (AT) nospam (DOT) au> wrote

Also note that MSCS supports instance level failover while DB Mirroring does
it at the database level. Check out
http://www.microsoft.com/technet/pro...n/sqlydba.mspx
which has a section on High Availability that talks about both MSCS and DB
Mirroring for SQL Server 2005.


joe.

"Hilary Cotter" <hilary.cotter (AT) gmail (DOT) com> wrote

You get a limited-scale version in Standard Edition

http://www.microsoft.com/sql/2005/pr...05features.asp

Geoff N. Hiten
Microsoft SQL Server MVP

"Ole Kristian Bangås" <olekristian.bangas (AT) masterminds (DOT) no> wrote