Data availability Microsoft has improved SQL Servers overall data availability by allowing administrators to perform maintenance and recovery tasks while a database is online. During tests, for example, eWEEK Labs was able to reindex a database while keeping it online. Microsoft also has added the ability to restore a database without bringing it offline. Users can still access tables that are not affected by the database restore process.Mirroring capabilities are included but not turned on in this initial release of SQL Server 2005. Currently an unsupported feature, SQL Server mirroring feature requires three servers: When the principal server fails, a witness server manages the failover to the mirror server. The mirror server can then be used to restore the principal server. Microsoft officials said their goal is to add support for mirroring to SQL Server 2005 in the first half of next year. Next Page: Common ground.
There have been a couple of tweaks to the way replication is handled in SQL Server 2005. Companies with a limited number of servers can now set up peer-to-peer transaction replication for real-time replication. This release of SQL Server also supports remote synchronization over HTTPS (HTTP Secure). And, given the importance of business intelligence to this release of the Microsoft database server, we werent surprised that cluster support now extends to analysis services.