Backup Exec 2010 and SQL 2008

Posted on 2011-04-22
Medium Priority
Last Modified: 2012-05-11
I am preparing to install Backup Exec 2010 R2 on a new server that will also have SQL 2008 installed. Is it better to install a new SQL 2005 Express instance with BU Exec, or use the existing SQL 2008 installation? The only direction I have found is in the Quick Installation Guide:
"When Backup Exec is installed into an existing instance, the automated master database restore feature is not available. To recover the Master database, replace it with the Master database copy that Backup Exec automatically creates and updates when the Master database is backed up. Caution: During the installation process and upgrade process, Backup Exec stops and starts the SQL service several times. Other user-created databases that use the SQL Server instance are unavailable during the process. To avoid such conflicts, you should install Backup Exec into its own SQL instance."

Are there any other considerations that help determine the best solution? Are there any reasons I shouldn't have SQL 2008 and SQL 2005 Express installed on the same server?
Question by:fisher_king
  • 2
  • 2
LVL 28

Expert Comment

ID: 35452629
As the text you pasted mentions BE may restart SQL services during updates. You don't really want to affect your production database when it happens. Maintenance becomes so much easier when you have a separate instance.
So, I would install a separate SQL 2005 Express instance to host Backup Exec. There are no drawbacks in having both versions of SQL side by side.
LVL 43

Accepted Solution

Eugene Z earned 2000 total points
ID: 35453253
..if you can install BE DB on excisting sql server -> you do not need maintain 2 sql servers: patching ,; avoid   extra resources consumtion by sql express , etc.

if you must have 2nd instance -> you can istall 2nd named instance of  sql 2008 of the same edition that you have (it is free on the same box)

I had sql 2005 std edition and sql express 2005 installed by BE install pack:
 as result I could not install sp4 on the default sql server 2005 std edition  (just on sql 2005 express)
Let say - I would recommend to have this small BE db on normal server ( it is very small and light db) without extra sql server install:

Author Comment

ID: 35453697
Thanks for both replies.

Will the second instance only use the hardware resources that it needs (minimal), or will it reserve resources and thus reduce those available to the SQL 2008 instance?
LVL 43

Expert Comment

by:Eugene Z
ID: 35453736
...it will use minimum HW (space for installation and memory, etc)...
..it may affect your another sql server instance...
..again: it is another sql server instance with full package of maintenences that you should provide, include in DR plan, security , etc ...
It is up to your environment requirments and policies: have or not to have this second instance

SQL Server 2005 Express Edition Features
1 gigabyte (GB) addressable RAM

4 GB maximum database size


Author Comment

ID: 35461799
Thanks again for the replies. I am going to go with EugeneZ's recommendation.

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Workplace bullying has increased with the use of email and social media. Retain evidence of this with email archiving to protect your employees.
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question