Local drive shows as a discon network drive - Can't attach SQL dat

Posted: 02-27-2008, 04:50 PM
I am attempting to attach a sql database on a remote server. There is a
drive0 which is a raid5 of 3 disks. That drive is in 2 partions, C: and D:.
C; is showing up as a local disk, D: is showing up as a Disconnected Network
Drive. When I try attaching the database through osql on either computer I
get:

Msg 5105, Level 16, State 4, Server MCASERVER1, Line 1
Device activation error. The physical file name
'd:\data\guestvision\fsamsdb_data.mdf' may
be incorrect.

I can browse to that file and it's all setup. If I try using the UNC it
tells me the file is on a network device not supported for database files.
I've turned off trace flag 1807. I also tried attaching it to the local disk
that is showing and I get the same error... Any ideas?
Reply With Quote

Responses to "Local drive shows as a discon network drive - Can't attach SQL dat"

 
LinkBack Thread Tools Display Modes
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
trouble moving files from local drive to network drive dwsdad Windows Vista Networking & Sharing 0 02-25-2008 12:32 PM
UPNP shows MP3 files on local c drive, but not when I add the d: d Geert Windows Vista Networking & Sharing 0 02-10-2007 10:16 AM
compressed drive shows only host drive Crusty \(-: Old B@stard :-\) Windows XP Hardware 0 09-13-2003 05:12 PM
cannot share USB2 drive over the local network rod_wade Windows XP Hardware 0 08-24-2003 05:13 AM
mapping a network drive to the local computer dave Windows XP Network & Web 2 07-03-2003 03:21 AM


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90