"ronald" <ronald@xxxxxx> wrote in message
news:2BD42B74-92D2-4401-8841-72197CDE078F@xxxxxx
Quote:
> I am setting up a development environment (SQL Server, etc.) in a guest VM
> and want to store all my souce code and databases on the host so that my
> data
> is always on the host as I add new guest VMs as the development
> environment
> tools get updated over time.
I have just tried to do the following:
1) Mapped a Z:\ drive pointing to another machine on my network
2) Launched SQL Server 2008 Management Studio
3) Started the "Create new database" wizard
4) Clicked on the Browse (...) button to select the new databases data and
log files - only the local drives were available, not the mapped Z:\ drive
5) Altered the location of the new database and log files manually to point
at the mapped Z:\ drive - this produced SQL Server error: 5133 "CREATE
DATABASE failed. Some filenames listed could not be created. Check related
errors."
Turns out that SQL Server doesn't support mapped drives by default because
of the massive degredation in performance. There is a trace flag which you
can enable which allows this, but Microsoft don't recommend it:
http://support.microsoft.com/kb/304261 Quote:
> It has been suggested to use regular Windows networking on the guest to
> access a shared folder on the host (instead of VPC Shared Folders), but I
> am
> not sure how to do this.
Exactly the same as you would on a physical machine - just make sure that
the VM's network adaptor is pointing at your host's physical NIC and not
e.g. NAT or Local Only...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net