SQL Server Files Local or NAS or SAN?
- by Jedi Master Spooky
I have to install a new Server with SQL Server 2008, What do you recommend, One server with Raid 10 or the Files in a NAS?
What about iSCSI should I use it?
What about SAN?
The server has 4Gb of RAM and that database file is about 2GB.
To make my self clear today the server has no RAID, I have to implement some kind of strategy so if something happend I can have my files safe, so What should I choose Local Files, NAS, SAN? What option has the most performance, what is the more secure?