Windows Server and SQL database upgrade

54,660 pts.
Tags:
SQL Server 2005
SQL Server Upgrade
Windows Server 2003 to Windows Server 2008 Upgrade
Windows Server 2008
Windows Server 2008 R2
Windows Server Upgrades
 We are goging to upgrade server, SQL server databases and domain name, now currently using as following setting 1. Server OS - Windows server 2003 Enterprise Edtion. 2. SQL server 2000 3. domaname xxx1 we are looking and upgrade to new os version, server SQL server and change domain name. 1.  Server OS - Windows server 2008 R2 2. SQL server 2005 and 2008 3. new domain name xxx2 As a SQLDBA, what are steps should be followed in SQL database upgradation?

Software/Hardware used:
Windows Server 2003 to Windows Server 2008 Upgarde, Windows Server 2008 R2, SQL Server 2005,
ASKED: September 24, 2009  3:25 PM
UPDATED: September 24, 2009  6:59 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

The domain name change is totally separate from the other upgrades. After the domain has been renamed the SQL Servers will need to be rebooted. Nothing else should need to be done after this. You can optionally change the names of the Logins and users to match the new domain name. You don’t have to however.

As for the system and SQL Server upgrade, if you are going to be upgrading the existing server, I would recommend that you backup the database and simply format the server. Changing the OS that SQL Server is running on via an upgrade is just asking for trouble. Especially as you plan on upgrading SQL Server after that.

Do a clean install of Windows 2008, then install SQL 2005 or SQL 2008, then restore (or attach) the databases to the new instance.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following