Microsoft Pushes SQL Server Closer To Continuous Availability - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

IoT
IoT
Software // Enterprise Applications
News
4/21/2006
05:10 PM
Connect Directly
Twitter
RSS
E-Mail
50%
50%

Microsoft Pushes SQL Server Closer To Continuous Availability

Service Pack 1 for SQL Server 2005 also forges tighter links between database and SAP application data.

Microsoft Can Check another item off its "to do" list in pursuing parity with database competitors. And administrators who manage Microsoft's SQL Server databases may have a slightly shorter worry list when it comes to database downtime.

Microsoft last week added data mirroring to SQL Server 2005, pushing its database onto the same high-availability playing field as Oracle and IBM DB2.

Data mirroring refers to a database's ability to generate an up-to-the-second copy of itself that can take over almost immediately if the primary database should fail. Oracle and IBM offer data mirroring as an option for their databases. Microsoft began providing the capability last week as part of Service Pack 1 for SQL Server 2005, the most up-to-date release of its database.

SQL Server 2005 already included the ability to take snapshots for reconstructing a database at a previous point in time. But data mirroring, which was to have been included in SQL Server 2005, was delayed for more testing. Mirroring comes closer to the "continuous availability" goal set by Microsoft senior VP Paul Flessner in a speech earlier this month. With mirroring, two database servers are linked, each creating the same log of events from a stream of transactions.

Microsoft's closer ties with SAP also were evident with this week's server pack release, which includes Reporting Services that work better with SAP's NetWeaver Business Intelligence, the data storehouse for SAP applications. Microsoft also will offer SAP NetWeaver-ready versions of its own business intelligence tool and a tool for querying the SAP Business Warehouse.

But it's the database mirroring that moves SQL Server the furthest. It puts it past "warm failover" capabilities, in which a database problem might result in a few minutes of downtime, to "hot failover," in which an outage remains nearly imperceptible to users. That might seem like an incremental benefit, but for DBAs, those minutes of downtime can be very long indeed.



Power Pack

Service Pack 1 for SQL Server 2005 also offers:






Reporting And Text Search:

The free SQL Server 2005 Express Edition is equipped with reporting and text search capabilities






Management Console:

SQL Server Management Studio Express is a graphical management tool for the free database






SAP BI Links:

SQL Server Reporting Services can more easily tap into NetWeaver Business Intelligence data



We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
Comment  | 
Print  | 
More Insights
News
How GIS Data Can Help Fix Vaccine Distribution
Jessica Davis, Senior Editor, Enterprise Apps,  2/17/2021
Commentary
Graph-Based AI Enters the Enterprise Mainstream
James Kobielus, Tech Analyst, Consultant and Author,  2/16/2021
Slideshows
11 Ways DevOps Is Evolving
Lisa Morgan, Freelance Writer,  2/18/2021
White Papers
Register for InformationWeek Newsletters
Video
Current Issue
2021 Top Enterprise IT Trends
We've identified the key trends that are poised to impact the IT landscape in 2021. Find out why they're important and how they will affect you.
Slideshows
Flash Poll