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 |
|
ann06
Posting Yak Master
171 Posts |
 Posted - 2009-01-18 : 08:57:00
|
| i read this answer in a testking question.Mapping a network drive to the server will increase the disk space available to the database but query time will be limited to the network environment and network transfer speeds. This will hamper query response time.can we create a database on a mapped network drive (sql2000)? |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-01-18 : 10:05:17
|
| You shouldn't be considering it. Ignoring the query time (which is not a small problem) putting data files on a network drive means that the slightest network glitch can lead to a corrupt database. It it Not A Good Idea.p.s. this is another reason (over the fact that it's cheating) not to use testking. Their answers are questionable at best, dead wrong at worst.--Gail ShawSQL Server MVP |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
|
|
|
|
|
mapping network drive to the server?