|
||||
|
Description
Microsoft SQL Server is a comprehensive, integrated data management and analysis software that enables organizations to reliably manage mission-critical information and confidently run today?s increasingly complex business applications. SQL Server allows companies to gain greater insight from their business information and achieve faster results for a competitive advantage. SQL Server includes support for database mirroring and clustering. A SQL server cluster is a collection of identically configured servers, which help distribute the workload among multiple servers. All the servers share an identical virtual server name, and it is resolved into the IP address of any of the identically configured machines by the clustering runtime. Automatic fail over clustering is also available, in which the workload of a server is transferred to another system in the event of a system failure.SQL server also supports data partitioning for distributed databases. Database mirroring, introduced in SQL Server 2005, allows creation of mirrors (or replicas) of database contents, along with transaction logs, on another instance of SQL Server, based on certain predefined triggers. Benifits
|