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 |
|
albertkohl
Aged Yak Warrior
740 Posts |
 Posted - 2010-06-09 : 02:29:57
|
| hey guys/girls... i got got a N8800 Thecus SAN that i'm trying to run a database off of, it's basically got 1TB Western Digital 7200 RPM Drives (x8) in it, and it's running a raid 5 iSCSI target.i was able to create a database, the .MDF is the only file that resides off the san. problem is now that i have it up and running, every time i try and insert data, i get the following error:Msg 823, Level 24, State 2, Line 2The operating system returned error 21(The device is not ready.) to SQL Server during a read at offset 0x0000000006a000 in file 'I:\MSSQL\DATA\SQL4\Supp.mdf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.Any ideas on why, or any thing i should configure so it will let this work? i'm guessing it's a slow-read issue or something, but i'm totally at a loss...Thanks! |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2010-06-09 : 13:04:47
|
| SQL Server databases are not supported on NAS storage. The storage has to appear to the system as local storage - which is probably the reason you are seeing these errors. |
 |
|
|
albertkohl
Aged Yak Warrior
740 Posts |
Posted - 2010-06-10 : 00:03:58
|
| new because it's an iSCSI target, doesnt that make it appear local? thought that was part of the point of iSCSI |
|
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2010-06-11 : 14:05:07
|
| I am not sure - it really depends upon how you have set up and configured the storage. From the error message, you either have it setup as a NAS - which is not supported, or you have connectivity problems which is going to cause corruption.Also, 7200RPM drives is quite slow for server based systems. I wouldn't go with anything less than 10,000 - and would normally request 15,000 for higher performing systems. |
|
|
|
|
|
|
|
|
Database Running off Raid5 NAS