I am moving from four servers with an independent database running on dual/quad 1GHZ server with 2GB of ram. The application server will remain, but the database will be consolidated on a single quad 3GHZ Xeon with 4GB of memory.
Over the next 12 months, many more solutions are going to be introduced with SQL Server 2005. I would also spend the time and money to thoroughly test the different options and become a pro with the solution you select, so that when a disaster strikes you can keep the SQL Server running that supports the business. Good luck!
Do you have comments on this Ask the Expert Q&A? Let us know.
Dig Deeper on SQL Server High Availability, Scalability and Reliability
Related Q&A from Jeremy Kadlec, Contributor
Adding non-clustered indexes to SQL Server columns and tables frequently queried is possible. Learn how to add non-clustered indexes to SQL Server ...continue reading
Learn how to view a query execution plan in SQL Server with SQL Server Management Studio or Query Analyzer. Review and decrease query plan sub tree ...continue reading
Want to change the collation to SQL Server 2005 standards after upgrading databases from SQL Server 2000? Learn the best approach involving DTS and ...continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.