[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Can Backup Exec 10d co-exist with SQL Express 2005?

Posted on 2008-01-25
4
Medium Priority
?
1,005 Views
Last Modified: 2013-12-01
I have a Windows 2003 R2 server running Backup Exec 10d. There is currently no other SQL instances installed or running on that server, although I do have Backup Exec running a backup of some SQL 2000 databases on another server (remote agent).

I would like to install SQL Express 2005 on the Backup Exec server, but I'm worried it may break or interfere with the Backup Exec database. Will there be any conflicts or should I keep anything in mind while installing SQL Express 2k5? I don't want to convert the Backup Exec database or anything like that... just leave it untouched.

Nightly backups are 10x more important than this little project, so I'm just trying to play it safe here.

Thanks
0
Comment
Question by:jmpriest
  • 2
  • 2
4 Comments
 
LVL 27

Expert Comment

by:ptjcb
ID: 20743360
SQL Express can be installed on different editions of Windows, including XP.

There shouldn't be a conflict with Backup Exec 10d, if you have already installed SP1, and SQL Express on the same computer, but why risk it?

There is also a Hotfix that you can apply, if you want to backup the SQL Express

http://seer.support.veritas.com/docs/280204.htm
0
 

Author Comment

by:jmpriest
ID: 20743780
I need somewhere to house a SQL Express 2005 database for a prototype intranet project. The backup server is currently our best option since it a powerful machine and isn't doing much beyond running backup exec and file sharing.

My main concern was installing SQL Express 2005 making some kind of changes to Backup Exec or interfering with it's communication to it's own database.

Thanks

0
 
LVL 27

Accepted Solution

by:
ptjcb earned 1000 total points
ID: 20743890
You would install SQL Express to its own instance, so that should not be a problem. The backup exec is configured to talk to its database and won't know that another one exists on the server.

You should monitor your resources on that server during the prototype project.

I would make it known to the powers that be that if they decide to develop the project, that the Backup Exec server is too important for development work. What are your options if the developers create a runaway query and you have to shut the server down to stop it?

Another issue that you must consider is that you are allowing access to that important server to other people. Even in an Intranet project, you should lock down the extended procedures (xp), so that no developer can create anything to do with xp_cmdshell, and lock away the SA user. Developers have a lazy habit of creating everything to access the SQL Server as SA, which has far too many permissions for something as mundane as looking at a view.




0
 

Author Comment

by:jmpriest
ID: 20744186
Good points and definitely something to think about.

I may just start pushing again for a cheap but upgradeable server with Windows 2003 Web Edition for my intranet project. The other current servers are completely out of the question, one being Exchange/DC and one holding the company's accounting databases.

Thank you so much
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

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

VM backup deduplication is a method of reducing the amount of storage space needed to save VM backups. In most organizations, VMs contain many duplicate copies of data, such as VMs deployed from the same template, VMs with the same OS, or VMs that h…
Among the most obnoxious of Exchange errors is error 1216 – Attached Database Mismatch error of the Jet Database Engine. When faced with this error, users may have to suffer from mailbox inaccessibility and in worst situations, permanent data loss.
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Suggested Courses

591 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