We tried it for several months and had nothing but problems with it. We connected our SQL servers to our F840 Filer using a private GigE backbone as NetApp suggested. Using both NT4 and Windows 2000, the transactions we were making would end up causing the redirector to fail and we would lose connection to the database. This is a flaw with Microsoft and not NetApp. These disconnects caused multiple database corruptions making us restore from older dumps. We have since moved all our SQL and Oracle databases back to local storage due to this problem.
There is a product called SnapDrive (I think) from NetApp. It basically replaces the redirector. You have to be using Win2k and SQL2k with a dedicated volume per database server. Unless you use that, I wouldn't recommend putting SQL databases on a Filer.
-----Original Message----- From: Carruthers, Paul A [mailto:Paul_Carruthers@AIMFUNDS.COM] Sent: Friday, March 15, 2002 8:53 AM To: 'toasters@mathworks.com' Subject: MS SQL Server
Anybody willing to share their experiences running SQL Server against their filers. Good or bad, both appreciated... :)
Cheers -- Paul.