Using SqlServer 2008 in cluster do I need to have the two servers installed with Windows in Cluster mode?
Windows 2008 Server Standard Edition, supports Component Load Balancing? if not, what SO do I need?
Does Windows 2008 Server Standard Edition, support Network Load Balancing?
I have a project with a 2TB database (450,000,000 rows). What is the recommend memory? There will be about 200 users at the same time using the info.
I have a project with a 2TB database ( 450.000.000 rows). I need to provide to the project a solution that gives FailOver and load Balacing, what do you recommend? We are going to use a NetApp Filer for the Data Files and for the File System of the Project.
I read that SQL Clustering does not provide load balacing. If I cannnot have this feature and I have to go only to the FailOver what Server ( I presume that the key feature here is memory) would you recomend. We are adding 1.000.000 rows a day. Once the rows is inserted we are doing a lot of updates to that row for about 1 week then the row get static. Because of this I am thinking in some kind of history table or database or something like that.
I am open to the Os servers implementation, I was thinking of a windows 2008 server with cluster but this depend of the database solution
I need to get the size of a directory, recursively. I have to do this every month or so. I want to make a powershell script to do it.
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?