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...
What were the circumstances leading up to attaching this library manually?
The error usually indicates that the file is most likely damaged.
-Hywell