Locating SQL Server Express on Network Drive

Question

Locating SQL Server Express on Network Drive

EddieN1

SSC-Addicted

Points: 492
More actions
July 27, 2014 at 5:56 am

#289063

I have an Instance of SQL Server 2008 R2 Express that I use exclusively for testing and development. I would like to locate it on a Network Drive that I can move from my Desktop, while I'm in my Home Office, to my Laptop, when I am on the road. Is there an easy way to do this? Thanks, Eddie

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 1

You can do this, but that can cause you issues with the files if access is not high speed. If you mean that you'll map the path to local drives differently, that's one thing. If you want to have this on a remote drive that you access across VPN, you're asking for trouble.

Here's guidance on using a network drive: http://blogs.msdn.com/b/varund/archive/2010/09/02/create-a-sql-server-database-on-a-network-shared-drive.aspx

Also support: http://support.microsoft.com/kb/304261