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?