Vault General Discussion

Vault General Discussion

Reply
Active Contributor
34 Posts
0 Kudos
Registered: ‎02-25-2009
Post 1 of 4

filenamne.mdf is not a primary database file.

1150 Views, 3 Replies
11-02-2011 12:30 AM

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...

Active Contributor
34 Posts
0 Kudos
Registered: ‎02-25-2009
Post 2 of 4

Re: filenamne.mdf is not a primary database file.

11-02-2011 12:44 AM 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...

Product Support
232 Posts
20 Kudos
Registered: ‎08-26-2008
Post 3 of 4

Re: filenamne.mdf is not a primary database file.

11-02-2011 05:53 AM 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.
Active Contributor
34 Posts
0 Kudos
Registered: ‎02-25-2009
Post 4 of 4

Re: filenamne.mdf is not a primary database file.

11-03-2011 03:26 AM in reply to: herrerh

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

 

My backup is old.. :´(

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
New button for Platinum & Gold Subscription customers
Gold & Platinum Subscription customers can alert Autodesk if they require assistance with their forum post

Manufacturing Community
The Manufacturing Community provides additional access to tips, tutorials, blogs and networking with peers.