Upgrade to SQL Server 2008 or SQL Server 2008 R2 with minimal downtime

In the last article I announced Microsoft running productive on SQL Server 2008 R2. In this article I’d like to tell more about how this upgrade was done with 5min downtime. Database Configuration of the Microsoft SAP ERP system As described in an earlier article on this blog (http://blogs.msdn.com/saponsqlserver/archive/2008/03/28/how-does-microsoft-perform-backups-in-their-sap-system-landscape.aspx), the HA configuration is based on… Read more

Microsoft’s SAP ERP system productive on SQL Server 2008 R2

Two weeks ago Microsoft’s SAP ERP system went productive on CTP2 (also named August CTP) of SQL Server 2008 R2. This move represents the most important step of 3 months testing of SQL Server 2008 R2 in sandbox systems, development and test systems. As throughout the whole testing period, the move to production was eventless…. Read more