I'm working on a project that involves a Windows 2000 network running Microsoft SQL Server 2000. The project requires more storage than our current 54GB of hard disk space. We're considering installing an external Quantum Snap Server. But will Win2K and SQL Server view the storage on the Snap Server the same as the storage on our internal RAID?
No. Furthermore, I'd never recommend installing SQL Server on a Snap Server. Performance would be less than par, to say the least.
You have two realistic alternatives. You can add a new SCSI array, which will probably last you a few years. Or, you can add a Fibre Channel array. The latter solution is ideal but expensive, so you need to weigh the cost against your needs.