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.

Software // Enterprise Applications
05:10 PM
Connect Directly

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
InformationWeek Is Getting an Upgrade!

Find out more about our plans to improve the look, functionality, and performance of the InformationWeek site in the coming months.

10 Things Your Artificial Intelligence Initiative Needs to Succeed
Lisa Morgan, Freelance Writer,  4/20/2021
Tech Spending Climbs as Digital Business Initiatives Grow
Jessica Davis, Senior Editor, Enterprise Apps,  4/22/2021
Optimizing the CIO and CFO Relationship
Mary E. Shacklett, Technology commentator and President of Transworld Data,  4/13/2021
White Papers
Register for InformationWeek Newsletters
Current Issue
Planning Your Digital Transformation Roadmap
Download this report to learn about the latest technologies and best practices or ensuring a successful transition from outdated business transformation tactics.
Flash Poll