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 |
|
bharathheyram
Starting Member
2 Posts |
 Posted - 2010-02-12 : 05:49:55
|
| Hi, I have got a strange error in sql server 2005 when i tried to open any table by right clicking on it or run a query in Management Studio, I am getting an error-"Directoty name is Invalid". From the forum i got a solution to either log off/Restart windows -I tried restarting windows and it worked for me. Now the issue is after 15 days again im getting the same error since our database is in main server everytime its not possible to restart/shutdown. Is there any permanent solution to this problem and because of what problem the error is occuring. Can any one help in resolving this issue?RegardsBharath Subramanaian |
|
|
DaleTurley
Yak Posting Veteran
76 Posts |
Posted - 2010-02-12 : 06:49:20
|
| What edition and serice pack do you have installed?Where are your database files? Are they on a SAN? |
 |
|
|
bharathheyram
Starting Member
2 Posts |
Posted - 2010-02-12 : 23:43:24
|
| Its Standard edition service pack 2 , Database files are in main server and they are on SAN.RegardsBharath Subramanaian |
|
|
|
DaleTurley
Yak Posting Veteran
76 Posts |
Posted - 2010-02-17 : 10:28:28
|
| It may be that SQL Server doesn't 'see' the SAN all of the time...What result do you get if you try EXEC xp_cmdshell 'dir <data directory>' after this error? |
|
|
|
|
|
|
Sql Server 2005-Directory name is invalid