Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Attaching a database to SQL Server in a virtual dev environment

  Asked By: Aiesha    Date: Jan 11    Category: Sharepoint    Views: 1227

I am running a Virtual Machine (Virtual PC) with the Litware image on it
containing Server 2003, SharePoint Server 2007 (version 12.0.6219.1000) , SQL
Studio Server Edition, Designer 2007, etc.

I have successfully copied the .mdf and .ldf files from my live SharePoint site
to a thumb drive. Now I need to install this to the SQL server in the virtual
environment. When I attempt to do this I get an error message:

The file [path name here] is on a network path that is not supported for
database files. I've tried moving the files from the thumb drive to the desktop
of the laptop on which the Virtual Machine is running. But I get the same error
message. I have File Sharing turned in the VPC settings where I can access the

At this point, I'm stumped and don't know what else to do. Can someone please
explain to me (in detail, as I am new to SQL Server and VPC)how to get the .mdf
file to attach in the virtual environment.



1 Answer Found

Answer #1    Answered By: Elijah Davis     Answered On: Jan 11

You need to either map a drive from the virtual  PC to the host machine  desktop
or drag the files from the host machine to the desktop inside the virtual PC.
Then put the files on one of the disk drives INSIDE the Virtual PC and mount
them into SQL from there.