Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
AskSQLTeam
Ask SQLTeam Question
0 Posts |
Posted - 2006-05-04 : 08:41:38
|
Ernie writes "I'm kind of new to SQL Database setup. Are you able to have SQL running on one machine and the data files, mdf and ldf, located on a NAS server?Example: I'm working with a Auditing Database that has grown so large we would like to move the data files to a NAS server that has more disk space.When I tried to use a mapped drive I would get an error that would say something like it must be a physical drive.Is there a script that can do what I need?Thanks" |
|
druer
Constraint Violating Yak Guru
314 Posts |
Posted - 2006-05-04 : 10:45:59
|
I have a NetApp SAN and am definately able to have mapped drives used to store data and logfiles. By mapped I mean that in Windows Explorer I've mapped say \\server\location to Y:. Then I tell SQL Server to use Y:\sub-directory and all is just fine.Hope it helps,DaltonBlessings aren't so much a matter of "if they come" but "are you noticing them." |
|
|
karenb
Starting Member
1 Post |
Posted - 2006-05-08 : 11:35:52
|
how do you tell sql to browse to the y:location? |
|
|
druer
Constraint Violating Yak Guru
314 Posts |
Posted - 2006-05-09 : 13:20:04
|
I should clarify since I just realized you might be talking about one of those network based hard drives (NAS) and not a SAN type storage device:1. Using Mapped drives - I use actual mapped drives for Backups NOT for the data files themselves.2. With the SAN, Windows thinks that the SAN storage is physically present so I use that for off-server storage for the actual data files.Sorry if I confused you,Dalton |
|
|
|
|
|