Q:
Windows Server and SQL database upgrade
Windows Server 2003 to Windows Server 2008 Upgrade, Windows Server 2008, Windows Server 2008 R2, SQL Server Upgrade, SQL Server 2005, 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,
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:
Sep 24 2009 3:25 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
A:
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
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.
