Again: Fail to attach mdf file to sql server,

Question

Original User: Jamal432@gmail.com

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

Clip_1052.jpg

Clip_1051.jpg

RowHighlight.gif

PolygonsUTM.zip

Tim_McGinnes_0-1624504376539.gif

EgQamqO8_400x400.jpg

Anonymous User · Answer

Original User: Jamal432@gmail.comUnfortunately, 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

Clip_1057.jpg

Clip_1055.jpg

Clip_1056.jpg

image.png

screen.png

AGOL_Basemap_Issue.JPG

ShannonShields · Answer

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