Fail to attach mdf file in the sql server,

678
4
Jump to solution
03-13-2013 10:51 AM
Highlighted
by Anonymous User
Not applicable
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
Reply
0 Kudos
1 Solution

Accepted Solutions
Highlighted
Honored Contributor
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-5558edc6...

best

Jamal

View solution in original post

Reply
0 Kudos
4 Replies
Highlighted
MVP Regular Contributor
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...
Reply
0 Kudos
Highlighted
by Anonymous User
Not applicable
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,
Reply
0 Kudos
Highlighted
Honored Contributor
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?
Reply
0 Kudos
Highlighted
Honored Contributor
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-5558edc6...

best

Jamal

View solution in original post

Reply
0 Kudos