October 8, 2003 at 2:48 am
We currently have a SQL 2000 database server running various databases with a capacity of 30gb. It is anticipated that we need more disk space in the future. The capacity of the server cannot be increased any further. Does anyone know the best approach to use to increase disk capacity for SQL Server?
To overcome this problem we are considering implementing a Storage Area Network or Network attached storage. Are SAN or NAS a viable solution? Which one is the better option for SQL Server?
October 8, 2003 at 7:37 am
quote:
We currently have a SQL 2000 database server running various databases with a capacity of 30gb. It is anticipated that we need more disk space in the future. The capacity of the server cannot be increased any further.
Why not? An external drive chassis is a lot cheaper and simpler than a SAN, and, with the right controller, will perform better.
quote:
Does anyone know the best approach to use to increase disk capacity for SQL Server?
For less than a terabyte, add more disks as local storage (see above).
quote:
To overcome this problem we are considering implementing a Storage Area Network or Network attached storage. Are SAN or NAS a viable solution? Which one is the better option for SQL Server?
Do not use NAS for SQL Server data. A SAN has the advantage of allowing clustering if you add that later.
--Jonathan
--Jonathan
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply