Video Screencast Help
Symantec Appoints Michael A. Brown CEO. Learn more.
Backup Exec

Backup Exec Install Blog (Why BE Installs a 32bit SQL 2008 Instance)

Created: 09 Jun 2014 • 8 comments • Translations available: 简体中文
Nick Elmer's picture
+3 3 Votes
Login to vote

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:

  1. The Microsoft SQL Server 2005 primary instance needed to be replaced due to its age and diminishing support.
  2. We have to support legacy OS platforms like Microsoft Windows 2003 Server and support for newer platforms like Microsoft Windows 2012 R2.
  3. Customers using older releases need a migration path.
  4. 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!

Comments 8 CommentsJump to latest comment

CraigV's picture

...will there come a time when SQL Express will run as an 64bit process?

Thanks!

Alternative ways to access Backup Exec Technical Support:

https://www-secure.symantec.com/connect/blogs/alte...

0
Login to vote
Nick Elmer's picture

Hi Craig,

Excellent question CraigV! We already support allowing our customer to use their own 64 bit instance today by selecting a custom instance (instead of the default one we install) when installing for the first time.

As for customers who are upgrading, we will continue to re-evaluate the impacts and trade-off's of the existing support and migrate the customer when there are compelling reasons to do so. Its always a difficult decision as it impacts every existing customer who upgrades!

Thanks,
Nick

0
Login to vote
MrK1024's picture

That's an excellent explanation and it makes sense.  Besides, customers that don't want to run the 32 bit version of SQL Server Express are free to install and manage their own instance and point BE to it.

0
Login to vote
Armin Kerl's picture

Very good Backround Information.

Can you give some Information about a new Deduplication Feature:

Ability to bypass the Windows localhost IPC bottleneck

Ability means that we have to configure someting?

I searched whole Manual and KB about this and did not find any Information.

thank you

0
Login to vote
Nick Elmer's picture

Thank You Armin! To followup on your question, can you help me understand where you saw this information documented? I'll do my best to get you an answer.

0
Login to vote
Armin Kerl's picture

In the Manual Page 50, Table 1-2

0
Login to vote
Nick Elmer's picture

Hi Amerin,

Backup Exec 2014 ships with a newer version of the DeDuplication component embeded in the product. The older version in previous releases of the product used a TCP/IP loopback interprocess communication (IPC) facility between our services and the client. In Backup Exec 2014 we have modified the communication facility to use a shared memory IPC instead. This results in a faster transfer with increased performance. Nothing is required on the users behalf to configure this feature. It is enabled and used by default.

Hope this answers your question.
Nick

 

0
Login to vote
Armin Kerl's picture

Great, thanks Nick for the Info

0
Login to vote