upgrade from 11d to 2010 rolls back at very end w/o error

[ilovebsod]

This was a 10D w/ MSDE install that was upgrade to 11D last week per this forum thread

https://www-secure.symantec.com/connect/forums/how-xfer-backup-selection-lists-policies-jobs-backup-...

When I attempted to run the 2010 install/upgrade the 1st time it errored out at the SQL 2005 install with this in the install log

V-225-53: ERROR: Failed to install SQL Express BKUPEXEC instance with error 29552. ***To search for information about this error, click here
07-19-2010,17:53:02 : Please review C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt for more details.

I performed the steps in the below article (deleted registry keys, removed the MSSQL$BKUPEXEC directory), then restarted the install and it was able to install SQL 2005 and get to the installing Backup Exec portion

http://www.symantec.com/business/support/index?page=content&id=TECH127893&actp=search&viewlocale=en_...

during the BE 2010 install portion I recieve this alert, but click yes to continue

The install gets to near completion per the images below, then the same BEDB error pops up. 

[ilovebsod]

the forum wouldn't let me type any more, continued:

if I click 'yes' to continue, the install starts to roll back until it gets to the 'view install log" screen. The install log shows that last BEDB error at 12:35, shows copying new files at 12:37, but shows no errors when it begings to roll back @ 12:56

<b><font color="red">03-03-2011,12:35:38 : V-225-204:  Could not start the SQL server ARES\BKUPEXEC with service name of MSSQL$BKUPEXEC  ***To search for information about this error, click <a href="http://entsupport.symantec.com/umi/V-225-204" target="main">here </a>

</font></b>

<br />

03-03-2011,12:35:38 : Setup will be unable to detach the BEDB database from SQL server ARES\BKUPEXEC because it has failed to establish a connection.  If you choose to continue with the Symantec Backup Exec 11d for Windows Servers removal, you will have to manually detach the BEDB database from SQL server ARES\BKUPEXEC.

Would you like to continue with the remove process?

<br />

03-03-2011,12:37:24 : Installing new services

<br />

03-03-2011,12:37:24 : Writing system registry values

<br />

03-03-2011,12:37:28 : Creating duplicate files

<br />

03-03-2011,12:37:33 : Copying new files

<br />

03-03-2011,12:38:17 : Moving files

<br />

03-03-2011,12:56:41 : Creating folders

<br />

03-03-2011,12:56:41 : Removing files

<br />

03-03-2011,12:56:55 : Removing system registry values

<br />

03-03-2011,12:56:55 : Removing ODBC components

<br />

03-03-2011,12:56:55 : Deleting services

<br />

03-03-2011,12:56:55 : Stopping services

<br />

03-03-2011,12:56:55 : RB_StopBEServices

<br />

03-03-2011,12:56:55 : CInstManagerOps::StopBEServices

<br />

03-03-2011,12:56:55 : Rolling back stop of BE services

<br />

03-03-2011,12:56:55 : Updating component registration

<br />

03-03-2011,12:57:06 : Action ended 12:57:06: INSTALL. Return value 2.

<br />

03-03-2011,12:57:06 : Property(S): DiskPrompt = [1]

<br />

03-03-2011,12:57:06 : Property(S): Registration = No

<br />

03-03-2011,12:57:06 : Property(S): UpgradeCode = {279D4253-B155-4E85-9FB8-F4CC81B5BFB8}

<br />

03-03-2011,12:57:06 : Property(S): ConfigInstall = **********

<br />

03-03-2011,12:57:06 : Property(S): RemoveInstall = **********

<br />

03-03-2011,12:57:06 : Property(S): StartBEServices = **********

<br />

03-03-2011,12:57:06 : Property(S): StopBEServices = **********

[ilovebsod]

If I restore the registry keys I deleted and the MSSQL$BKUPEXEC directory I'm able to run the 11d install.

How can I get the 2010 upgrade to complete?

Thanks in advance.

[Sush--- · Accepted solution]

Before you perform any troubleshooting, I would suggest you to stop all Backup Exec services and SQL service and make a copy of  the DATA, DATABACKUP and the CATALOGS folders to different location.

What is the version of SQL on which your BE 11d installation is running??

Check the following technote:

http://www.symantec.com/docs/TECH68954 : Upgrading Backup Exec fails to upgrade the named MSDE Instance of Backup Exec to SQL Express with "Failed to install SQL Express BKUPEXEC instance error 29552

http://www.symantec.com/docs/TECH70004 : Upgrade from Backup Exec for Windows Servers 10d to Backup Exec 11d or above fails because the MSDE upgrade to SQL Express fails (Error 29552)

Thanks,

-Sush...

[ilovebsod]

Thanks for the response!  currently the database (on 11d) is MSDE.

I found that dotnet article, but since I was seeing the exact error referenced in the "delete SQL" article I decided to go that route.

I'm going to attempt to repair or uninstall Dotnet 2.0, afterwards would you recommend I attempt a straight upgrade from 11d to 2010 or should I delete the MSDE database again before running the upgrade?

[Sush---]

Since your BE 11d is using MSDE , this could be the reason why the upgrade is failing. Because ideally BE 11d uses the SQL Express 2005 instance for the database. So first you will have to upgrade your SQL.

Here are the steps how you can perform it.

1) From Microsoft website download SQL Express 2005. If you have the BE 11d Installable Media then you can use the SQL Express 2005 installation files from that too.

2) Install the SQL Express 2005 and named the instance something like BACKUPEXEC

3) Go to C:\Program Files\Symantec\Backup Exec and run the BeUtility.exe

4) Click on All Media server and then on the right side Right click on your server name

5) Select the option New Backup Exec Database location

6) A small window will open which will allow you to select the name of the new SQL Instance. It will be in the format servername\BACKUPEXEC

7) Click OK and let that process be successful.

8) Now you can try to upgrade from BE 11d to BE 2010

Let me know if you face any issue.

Thanks,

-Sush...

[ilovebsod]

the 2nd article (copy the DLL, repair BE 11d) worked!

http://www.symantec.com/business/support/index?page=content&id=TECH70004 

Thanks Sush!