?
Solved

SERVER OS and DB Migration

Posted on 2013-12-24
5
Medium Priority
?
106 Views
Last Modified: 2014-06-23
Team,
 Find the attached existing setup. Planning to migrate to OS 2008 R2 64 bit in all servers and SQL 2008 64 bit in Database Servers without disturbing day to day work. Please find the plan,

Suggest.
Current-Setup.jpg
Steps-and-suggestion.docx
0
Comment
Question by:dinagaran2000
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 12

Expert Comment

by:Dave
ID: 39738922
You can't have two servers with same name on the network at the same time so you either have to re-configure app to talk to servers with different names or look at renaming servers.

I would upgrade Active Directory first.

Is all this physical servers? I also would look at using Virtualization to provide hardware resilience.
0
 

Author Comment

by:dinagaran2000
ID: 39747306
Sorry. I think VM wont perform well for SQLDB in cluster mode.
Will Domain and additional domain can be upgraded from 2003 R2 32 bit to 2008 R2 64 bit without formatting?
0
 
LVL 12

Expert Comment

by:Dave
ID: 39749537
1. Whilst an  upgrade from 2003r2 to 2008r2 won't actually re-format the disk it doesn't preserve any applications or profiles.

2. Sorry , certainly in Hyper-V SQLDB will perform well in cluster mode, but I wouldn't run it in cluster mode. I would use VMware HA to provide hardware resilience. In Hyper-V use HyperV clustering rather than SQL clustering. I can't comment on SQL performance in Hyper-V.
0
 

Accepted Solution

by:
dinagaran2000 earned 0 total points
ID: 40144022
Sorry Team,
          We have dropped the DB migration as of now
0
 

Author Closing Comment

by:dinagaran2000
ID: 40151489
We dropped the migration as of now
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question