I am ready with In-Place and went to Sr.DBA Manager,
He rejected and he want 100% Database guarantee and 100% safe, down time does not matter for him and recommended me go a head with Side by Side.
1.If detach Database from SQL2k and attach to SQL2k8,I don't think it is possible to attach back...is it correct
2. Is it required Create new cluster group for SQL2k8?
3. In 2 case what are the cluster groups I have to Create
4. Is it required to change connecting string from application?
5. If it is where i have to modify the connecting string in application level or in Database server level?
6. What are the settings can I take care after installing new sql server instance?
7. Is it required new virtual instance name for new installation (Instance)?
8.Is there any way to use existing virtual instance name for New instance?(so I belive no Need to change connecting string in application)
10.Is it possible to change instance name?(Old instance name to some other name and new instance name as existing instance name).
View Complete Post