Microsoft Sql Server 2005 - Same DB Name but different file locations
Posted on 2014-11-21
I have a program that uses sql server 2005. I did not write it, its an app from our vendor. It was made to run alone on a users PC. I'd like to deliver the app through Xenapp. What I'd like to know is: Can you have the same DB name but different filenames? I'd like to store the files (MDF, LDF) on a shared drive using the %USERNAME% variable. That way everyone's data would be unique to them. We cannot share the DB.
So my thought was we start a single Sqlserver and load the DB's (Same name but different filenames) so that everyone has access their own data.
Or when each user logs in we have multiple Sqlserver instances running. Not sure what that would do to performance. We have vSphere 5.1 - Citrix 7.1 - Sqlserver 2005.