Go 4 Sharepoint

Search:

Welcome: Guest!

Sharepoint Forum

Home » Forum » Sharepoint

Ask a question

RSS Feeds

Attaching a database to SQL Server in a virtual dev environment

Asked By: Aiesha Amin Date: Jan 11, 2009 Category: Sharepoint Views: 400

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
drives.

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.

Tagged:attaching database to sql server in virtual dev environment

1 Answer Found

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

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.

Didn't find what you were looking for? Find more on Attaching a database to SQL Server in a virtual dev environment Or get search suggestion and latest updates.