Hello again! Today, I want to address a question that I anticipate some customers may ask: "Why does Backup Exec 2014 install a 32-bit instance of Microsoft SQL Server 2008 during clean installs and upgrades?"
This topic received much discussion as we were deciding which version of SQL to use for Backup Exec 2014. There were several requirements:
- The Microsoft SQL Server 2005 primary instance needed to be replaced due to its age and diminishing support.
- We have to support legacy OS platforms like Microsoft Windows 2003 Server and support for newer platforms like Microsoft Windows 2012 R2.
- Customers using older releases need a migration path.
- Customers may experience failures when upgrading to a newer SQL instance, and they need a clean, workable rollback.
The only version of SQL that met all of those requirements and provided the best solution for our customers was Microsoft SQL Server 2008 32-bit, which:
- Allows customers to upgrade from Microsoft SQL Server 2005 up to Microsoft SQL Server 2008 and retain existing settings.
- Supports Microsoft Windows 2003 Server platforms and also Windows 2012 R2 Server platforms.
- Allows rollbacks if there are failures.
- Doesn’t require installing a newer version of MSI on an older system which requires a reboot during install.
We evaluated Microsoft SQL Server 2008 64 bit, but there is an upgrade dilemma that prohibits two BKUPEXEC instances from running simultaneously. If we removed the Microsoft SQL Server 2005 instance and installed a Microsoft SQL Server 2008 64 bit instance, there would be no provisions for rollback in failure situations. This would keep the customer from working during the diagnosis of the issue. There was no upgrade dilemma with the 32-bit instance.
Performance testing validated our decision. We ran the software under both instances on the same system and saw marginal differences between the Microsoft SQL Server 2008 32 and 64 bit instances.
Taking all of that into account, we believe we made the right choice for Backup Exec 2014. We welcome your feedback and questions for future releases!