If you run SQL Server 2005 Standard Edition in compliant mode 80, can you
still utilize log shipping, database mirroring, or clustering? If it is

you can't do mirroring as it is supported on the enterprise edition.
Clustering is supported and will work in 80 mode. Log shipping doesn't need
the wizards, so you can build it on any version or SKU of SQL server.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

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



[quoted text, click to view]