Microsoft SQL Server: Difference between revisions

Revision as of 12:16, 27 October 2014

Revision as of 06:33, 28 October 2014

Line 84:

Service Pack 1 (SP1) of SQL Server 2005 introduced Database Mirroring,<ref group=Note>Database Mirroring was included in the first release of SQL Server 2005 for evaluation purposes only. Prior to SP1, it was not enabled by default, and was not supported by Microsoft.</ref><ref>{{cite web|url=http://support.microsoft.com/kb/907741 |title=Issues to consider when you use the database mirroring feature in the initial release of SQL Server 2005 |publisher=Support.microsoft.com |date=2007-11-20 |accessdate=2011-09-04}}</ref> a high availability option that provides redundancy and failover capabilities at the database level. Failover can be performed manually or can be configured for automatic failover. Automatic failover requires a witness partner and an operating mode of synchronous (also known as high-safety or full safety).<ref>{{cite web|url=http://msdn.microsoft.com/en-us/library/ms189590.aspx |title=Automatic Failover |publisher=Msdn.microsoft.com |date= |accessdate=2011-09-04}}</ref>

<ref></ref>===SQL Server 2008===

SQL Server 2008 (formerly codenamed "Katmai") <ref name="2k8">{{cite web| url = http://www.microsoft.com/sql/prodinfo/futureversion/default.mspx | title = Microsoft SQL Server 2008| accessdate=2007-04-06}}</ref><ref name=PaulFlessner>{{cite web|title=ChannelWeb: Next SQL Server stop: Katmai|url=http://www.crn.com/storage/170702999|accessdate=2005-11-05}}</ref> was released on August 6, 2008<ref>Announced to the SQL Server Special Interest Group at the ESRI 2008 User's Conference on August 6, 2008 by Ed Katibah (Spatial Program Manager at Microsoft)</ref> and aims to make data management [[self-tuning]], self organizing, and self maintaining with the development of ''SQL Server Always On'' technologies, to provide near-zero downtime. SQL Server 2008 also includes support for [[structured data|structured]] and semi-structured data, including digital media formats for pictures, audio, video and other multimedia data. In current versions, such multimedia data can be stored as [[Binary large object|BLOBs]] (binary large objects), but they are generic bitstreams. Intrinsic awareness of multimedia data will allow specialized functions to be performed on them. According to [[Paul Flessner]], senior Vice President, Server Applications, [[Microsoft|Microsoft Corp.]], SQL Server 2008 can be a data storage backend for ''different varieties of data: XML, email, time/calendar, file, document, spatial, etc'' as well as perform ''search, query, analysis, sharing, and synchronization'' across all data types.<ref name=PaulFlessner />