topic Re: Again: Fail to attach mdf file to sql server, in Data Management Questions

Again: Fail to attach mdf file to sql server,

Anonymous User — Tue, 30 Apr 2013 18:22:37 GMT

Original User: Jamal432@gmail.com

Again: Fail to attach mdf file to sql server,

In my previous thread, the failure to attach mdf file to the sql server database was due to permission issue,

http://forums.arcgis.com/threads/79782-Fail-to-attach-mdf-file-in-the-sql-server?p=281670#post281670

the new failure is due to that the mdf file is not a primary database file (screenshot below):

[ATTACH=CONFIG]23881[/ATTACH], [ATTACH=CONFIG]23882[/ATTACH]

what might be the issue?

Best

Jamal

Re: Again: Fail to attach mdf file to sql server,

ShannonShields — Tue, 30 Apr 2013 21:22:00 GMT

Unfortunately, this error generally indicates some sort of corruption, probably of the database file header. You can try attaching with the sp_attach_single_db or CREATE DATABASE ... FOR ATTACH commands and see if any additional information is provided. Otherwise, restore the database from a backup.

-Shannon

Re: Again: Fail to attach mdf file to sql server,

Anonymous User — Wed, 01 May 2013 05:13:56 GMT

Original User: Jamal432@gmail.com

Unfortunately, this error generally indicates some sort of corruption, probably of the database file header. You can try attaching with the sp_attach_single_db or CREATE DATABASE ... FOR ATTACH commands and see if any additional information is provided. Otherwise, restore the database from a backup.

-Shannon

Thank you Shannon for the help,

Sorry, but I couldn�??t figure out how to �??attach with the sp_attach_single_db or CREATE DATABASE�?�.

[ATTACH=CONFIG]23894[/ATTACH], [ATTACH=CONFIG]23895[/ATTACH]

May you please elaborate a bit more?

By the way, I�??m trying to attach my mdf file from the backup itself which is an external hard drive of 2TB. We use the �??AllWay sync�?� software (http://allwaysync.com/) to back up our data.

[ATTACH=CONFIG]23896[/ATTACH]

Does this mean that our backup is corrupted? And then all our mdf files are corrupted in our backup? How come they work on the original source?

My idea is that the mdf files are difficult to be managed! They are not as flexible as the gdb or mdb, for example.

Best

Jamal