Video Screencast Help
Search Video Help Close Back
to help

event ID 5173 one or more files do not match the primary file of the database

Created: 09 Feb 2012 | Updated: 29 Feb 2012 | 3 comments
Matt00001's picture
Matt00001 Partner Accredited Certified
0 0 Votes
Login to vote

Hi

I unstalled backup exec 2010 and deleted its SQL instance and now am trying to install 2012 beta 3.   I get the error listed above toward the end of the install.  If I try and manually attach the database in SQL manager I get the same error.  It appears to be an issue with the base .mdf from the iso.   What am I missing?

 

Thanks

 

-Matt

Discussion Filed Under:
, , , ,
Group Ownership:

Comments 3 Comments • Jump to latest comment

Sush...'s picture
Sush... Symantec Employee Accredited
event ID 5173 one or more files do not match the primary file of the database - Comment:09 Feb 2012 : Link

What you can try is to install SQL seperately with another (different) Instance name and then during the Backup Exec installation select Use Existing SQL option to select the SQL instance which you have created.

Let us know if that helps.

 

Thanks,

-Sush...

Hope this piece of Information Helps you... and if it does then mark this response as Solution....!!!

+1
Login to vote
  • Actions
Matt00001's picture
Matt00001 Partner Accredited
event ID 5173 one or more files do not match the primary file of the database - Comment:14 Feb 2012 : Link

The problem seems to be that I did not manually remove the database files (I dropped the database, but did not remove the files).   This time I dropped the database, deleted all the registry keys, then deleted all the files in the program files directory and then deleted the .mdf and ldf files.

 

All worked after that.  Thanks for pointing me in the right direction.

0
Login to vote
  • Actions
Nick Elmer's picture
Nick Elmer Symantec Employee
event ID 5173 one or more files do not match the primary file of the database - Comment:12 Feb 2012 : Link

Hi Matt,

The SQL error message is saying the the MDF and LDF are not a matching pair.

I read your post above, and I would suggest that you try the gold version of 2012 which I believe is still available for download via the FA program. Not sure how long before it will be available on File Connect. Since you have the Beta, you should be able to email the beta cordinator and get access to the FA if you do not already have it.

When you install clean, make sure that the C:\Program Files\Symantec\Backup Exec\Data folder is not present. By default we will load our database files from that directory if you take the selected default SQL Server radio button during the install. If you select your own instance, then we will load the database files from your SQL Servers default database file location.

Hope this helps,
Nick

+1
Login to vote
  • Actions