Solved

Conflict with SQL Server Database Instance and Acornis BAckup Software

Posted on 2011-02-18
2
552 Views
Last Modified: 2016-10-27
Hello Experts,

I have SQL Server Express running a backend database for one of my Appliications on a Windows XP computer...

The SQL Server instance was stopped and would not restart after Acronis Backup software was installed.

1. When you try to restart the Service you get permission errors (Loacal System, User Administrator etc)
2. I tried uninstalling and re-installing the SQL Instance for my Application

- The Uninstall failed but it acts like the instance has been removed ("No Instances available" in Add New Programs now) allthough a new install thinks the instance is still there and won't install

Has anyone heard of a conflict between Acronis Backup Software install and previously installed (and functioning) SQL Instances?

Thanks!
0
Comment
Question by:Saxitalis
2 Comments
 
LVL 38

Accepted Solution

by:
Jim P. earned 500 total points
ID: 34935502
I haven't heard of an issue between Acronis and SQL, but you never know.

As far as this:
The Uninstall failed but it acts like the instance has been removed ("No Instances available" in Add New Programs now) although a new install thinks the instance is still there and won't install

By default SQL tries to install to the path: x:\Program Files\Microsoft SQL Server\MSSQL.1 (or 2,3,...).

And if you have an incomplete SQL uninstall (which is every single one I've ever done) you run into path and registry conflicts. Make sure you have copies of your .mdf/.ldf files off to the side. Then delete the MSSQL.x paths that aren't for Acronis. After that download a registry cleaner and delete the SQL Server registry entries.

Then from there the install should work.
0
 

Author Closing Comment

by:Saxitalis
ID: 35047326
Thanks - this issue has not been resolved because it is not possible to access the computer at this time but I am going to try your solution when opportunity permits...
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

762 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now