Unanswered: Risks related to clustering/unclustering
Our Software solution is on SQL 7 currently. It is implemented on a Clustered DB structure in production. Now the techies here are telling me that it is very difficult to setup this clustered db environment in a test area. This introduces a risk where we will be testing the new version which is on SQL 2K on a single DB, whereas the actual migration in production will be done in a Clustered DB setup.
The questions I have are :
1. What’s your view on setting up a clustered Test DB (Total DB size is about 30 GB) ?
2. What’s the complexity involved in upgrading the DB from SQL 7 to SQL 2K?
3. What are the risks involved in simulating the upgrade on a single DB as opposed to a clustered DB?