Melissa

write caching disk controllers offer good performance improvements but must
guarantee transaction security of writes otherwise you will get corrupt
databases. Ensure that the disk controller has been designed for the
environment which usually means it has a battery backup on board to preserve
data if there is a sudden loss of power. Also ensure that if you implement
this to check the life of the battery's and ensure they are replaced when
need be.





-----Original Message-----
From: Melissa Faga [mailto:[Email Address Removed] Tuesday, August 13, 2002 8:16 AM
To: '[Email Address Removed] write-caching disk controller


Can someone explain to me why we shouldn't use a write-caching disk
controller with our SQL Server? I was just reviewing some SQL 7.0
documentation and it includes a CAUTION against write-cashing disk
controllers. Any information you have, would be appreciated.

Melissa


Melissa Faga
GIS/DB Manager
City of Redmond
425-556-2134
[Email Address Removed] unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page