AnsweredAssumed Answered

Fail to attach mdf file in the sql server,

Question asked by geonetadmin on Mar 13, 2013
Latest reply on Mar 15, 2013 by Jamal432@gmail.com

Like • Show 0 Likes0
Comment • 4

Original User: Jamal432@gmail.com

Fail to attach mdf file in the sql server,

My mdf file is stored in the root of my hard drive (F:\).

[ATTACH=CONFIG]22581[/ATTACH]

I tried to to attach it to the sql server but I got the message below:

[ATTACH=CONFIG]22582[/ATTACH], [ATTACH=CONFIG]22586[/ATTACH]

Then I copied this file to my D drive and it is successfully attached!

[ATTACH=CONFIG]22583[/ATTACH], [ATTACH=CONFIG]22584[/ATTACH]

What might be the issue then?

Why this mdf file fails to attach while being stored in the F:\ drive?

Thank you

Best

Jamal

Jamal432@gmail.com Mar 15, 2013 2:03 PM

Correct Answer

Jamal,

Its a permissions based issue.

Right click on SQL Server Management Studio and Run As Administrator. Try the attach. It should resolve the issue for you.

Regards,

Hi guys,

I got the solution in the link below

http://social.msdn.microsoft.com/Forums/en-US/databasedesign/thread/274d3860-137e-4cd5-9635-5558edc682bd

best

Jamal

See the reply in context

Attachments

Clip_510.jpg83.9 KB
Clip_509.jpg156.4 KB
Clip_508.jpg168.8 KB
Clip_511.jpg182.4 KB
Clip_507.jpg153.2 KB

No one else had this question

Outcomes

mboeringa2010 Mar 13, 2013 11:44 AM

Jamal,

Is your F: drive a removable disk? Sometimes these things only work for fixed internal disks. And sometimes you aren't allowed to put a file in root either... I have seen many of these similar issues with multiple different programs. E.g. I recently discovered I wasn't able to use an external disk attached to a front USB port of my desktop as the backup drive for a Windows 7 system backup. When I attached it to a back USB port (directly connected to the mainboard), it worked like a charm...

Actions

geonetadmin Mar 13, 2013 11:59 AM

Original User: asrujit

Jamal,

Its a permissions based issue.

Right click on SQL Server Management Studio and Run As Administrator. Try the attach. It should resolve the issue for you.

Regards,

Actions

Jamal432@gmail.com Mar 14, 2013 10:49 AM

Jamal,

Its a permissions based issue.

Right click on SQL Server Management Studio and Run As Administrator. Try the attach. It should resolve the issue for you.

Regards,

Thank you guys for the contribution,

1. First, I thought that this problem is because it is stored in an external hard drive or on the root. In other cases, this file is neither stored in an external nor in the root, nevertheless it didn�??t work and the error persists to exit!

2. I tried to start the �??SQL Server Management Studio�?� but the the error persists to exit!

[ATTACH=CONFIG]22613[/ATTACH], [ATTACH=CONFIG]22614[/ATTACH], [ATTACH=CONFIG]22615[/ATTACH][ATTACH=CONFIG]22615[/ATTACH]

What other alternatives should I try?

Attachments

Clip_526.jpg161.6 KB
Clip_525.jpg8.0 KB
Clip_524.jpg105.9 KB

Actions

Jamal432@gmail.com Mar 15, 2013 2:03 PM

Jamal,

Its a permissions based issue.

Right click on SQL Server Management Studio and Run As Administrator. Try the attach. It should resolve the issue for you.

Regards,

Hi guys,

I got the solution in the link below

http://social.msdn.microsoft.com/Forums/en-US/databasedesign/thread/274d3860-137e-4cd5-9635-5558edc682bd

best

Jamal

Actions

4 Replies

mboeringa2010 Mar 13, 2013 11:44 AM
Mark Correct
Correct Answer
Jamal,

Is your F: drive a removable disk? Sometimes these things only work for fixed internal disks. And sometimes you aren't allowed to put a file in root either... I have seen many of these similar issues with multiple different programs. E.g. I recently discovered I wasn't able to use an external disk attached to a front USB port of my desktop as the backup drive for a Windows 7 system backup. When I attached it to a back USB port (directly connected to the mainboard), it worked like a charm...
Like • Show 0 Likes0
Actions
geonetadmin Mar 13, 2013 11:59 AM
Mark Correct
Correct Answer
Original User: asrujit

Jamal,

Its a permissions based issue.

Right click on SQL Server Management Studio and Run As Administrator. Try the attach. It should resolve the issue for you.

Regards,
Like • Show 0 Likes0
Actions
Jamal432@gmail.com Mar 14, 2013 10:49 AM
Mark Correct
Correct Answer
Jamal,

Its a permissions based issue.

Right click on SQL Server Management Studio and Run As Administrator. Try the attach. It should resolve the issue for you.

Regards,

Thank you guys for the contribution,

1. First, I thought that this problem is because it is stored in an external hard drive or on the root. In other cases, this file is neither stored in an external nor in the root, nevertheless it didn�??t work and the error persists to exit!

2. I tried to start the �??SQL Server Management Studio�?� but the the error persists to exit!

[ATTACH=CONFIG]22613[/ATTACH], [ATTACH=CONFIG]22614[/ATTACH], [ATTACH=CONFIG]22615[/ATTACH][ATTACH=CONFIG]22615[/ATTACH]

What other alternatives should I try?
Attachments
- Clip_526.jpg161.6 KB
- Clip_525.jpg8.0 KB
- Clip_524.jpg105.9 KB
Like • Show 0 Likes0
Actions
Jamal432@gmail.com Mar 15, 2013 2:03 PM
Unmark Correct
Correct Answer
Jamal,

Its a permissions based issue.

Right click on SQL Server Management Studio and Run As Administrator. Try the attach. It should resolve the issue for you.

Regards,

Hi guys,

I got the solution in the link below

http://social.msdn.microsoft.com/Forums/en-US/databasedesign/thread/274d3860-137e-4cd5-9635-5558edc682bd

best

Jamal
Like • Show 0 Likes0
Actions

GeoNet

The Esri Community

Fail to attach mdf file in the sql server,

Attachments

Outcomes

Attachments

Related Content

Recommended Content