PC Review Forums Newsgroups Windows XP Windows XP Configuration Local drive shows as a discon network drive - Can't attach SQL dat

Reply

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

 
Thread Tools Rate Thread
Old 27-02-2008, 05:50 PM   #1
skeith
Guest
 
Posts: n/a
Default Local drive shows as a discon network drive - Can't attach SQL dat


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
Reply



Thread Tools
Rate This Thread
Rate This Thread:

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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off