Community
Vault Forum
Welcome to Autodesk’s Vault Forums. Share your knowledge, ask questions, and explore popular Vault topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

filenamne.mdf is not a primary database file.

3 REPLIES 3
Reply
Message 1 of 4
cedergren
1672 Views, 3 Replies

filenamne.mdf is not a primary database file.

Hi.

 

When i try to attach my library i get an error saying:

c:\Programfiles (x86)\Microsoft SQL Server\MSSQL\Data\AI2010_Nordform.mdf is not a primary database file.

 

The error.log file says:

 

2011-11-02 08:21:19.51 spid54      Starting up database 'Vault'.
2011-11-02 08:21:57.36 Logon       Error: 18456, Severity: 14, State: 8.
2011-11-02 08:21:57.36 Logon       Login failed for user 'sa'. [CLIENT: <local machine>]
2011-11-02 08:21:57.39 spid51      Starting up database 'AI2010_Inventor ISO'.
2011-11-02 08:21:57.48 spid51      Setting database option SINGLE_USER to ON for database AI2010_Inventor ISO.
2011-11-02 08:21:57.48 spid51      Setting database option SINGLE_USER to ON for database AI2010_Inventor ISO.
2011-11-02 08:22:05.96 Logon       Error: 18456, Severity: 14, State: 8.
2011-11-02 08:22:05.96 Logon       Login failed for user 'sa'. [CLIENT: <local machine>]
2011-11-02 08:22:13.07 spid51      Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
2011-11-02 08:22:13.07 spid51      Configuration option 'xp_cmdshell' changed from 0 to 1. Run the RECONFIGURE statement to install.
2011-11-02 08:22:13.08 spid51      Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.
2011-11-02 08:22:13.13 spid51      Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
2011-11-02 08:22:13.13 spid51      Configuration option 'xp_cmdshell' changed from 1 to 0. Run the RECONFIGURE statement to install.
2011-11-02 08:22:13.15 spid51      Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.
2011-11-02 08:22:13.15 spid51      Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
2011-11-02 08:22:13.15 spid51      Configuration option 'xp_cmdshell' changed from 0 to 1. Run the RECONFIGURE statement to install.
2011-11-02 08:22:13.16 spid51      Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.
2011-11-02 08:22:13.22 spid51      Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
2011-11-02 08:22:13.22 spid51      Configuration option 'xp_cmdshell' changed from 1 to 0. Run the RECONFIGURE statement to install.
2011-11-02 08:22:13.22 spid51      Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.
2011-11-02 08:25:04.09 spid52      Starting up database 'Vault'.

 

 

 

Can the size of the Vault.mdf generate this problem. The database file is 3,983GB...

3 REPLIES 3
Message 2 of 4
cedergren
in reply to: cedergren

Skärmklipp.JPG

 

If I look at Propertys for AI2010_Nordform.mdf it says that it is a primary database file...

Message 3 of 4
herrerh
in reply to: cedergren

What were the circumstances leading up to attaching this library manually?

 

The error usually indicates that the file is most likely damaged.

 

-Hywell



Hywell Herrero
Data Management Support Specialist
Product Support
Autodesk, Inc.
Message 4 of 4
cedergren
in reply to: herrerh

Is there anyone who can help me to recover a corrrupt .mdf file? pls...

 

My backup is old.. :´(

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report