Seeking Upgrade Advice - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Old Forums

CLOSED - SQL Server 2005/Yukon

Seeking Upgrade Advice

Author

Topic

Kbalz
Yak Posting Veteran

94 Posts

Posted - 2006-04-17 : 14:43:48

I've been reading articles for hours but haven't come across any that are upgrading in this way:

Going from: SQL Server 2000 SP3 (32-bit), Running on Windows Server 2003 Standard Ed. (32-bit)

Going to: SQL Server 2005 64-bit, Running Windows Server 2003 Standard, 64-bit (New server and hardware)

We'd like to keep the same IP and Server name, and take the "old" SQLserver off the domain, format, and move our PDC on to that hardware.

This gets a little off track of just SQL 2005, but any articles you can point me to would be much help. I just want to make sure we get this right, without loosing data and avoiding long down-times.

Kbalz
Yak Posting Veteran

94 Posts

Posted - 2006-04-17 : 14:55:14

I've already set up the new server, my thought was:

(think "Server1" as my current SQL Server's name)

Join the Server to the domain as "Server2"
Install SQL Server 2000
Migrate all data from Server1 to Server2 with this process http://www.delphifaq.com/faq/databases/mssql/f753.shtml

Use the Upgrade Process to upgrade from 2000 to 2005
Take Server1 off the domain
Rename Server2 to Server1
Set up IPs in DNS on the Domain Controller and on Server1

As far as upgrading the DC to the old-sql-server, I have found these guides that look good:
http://support.microsoft.com/default.aspx/kb/324801?
http://www.petri.co.il/forums/showthread.php?t=1058

Am I missing any steps? My concern lies with the Upgrading from 32-bit SQL 2000 to 64-bit 2005

Kbalz
Yak Posting Veteran

94 Posts

Posted - 2006-04-18 : 07:55:36

Restoring the database from .BAK worked great - and we've decided to use a new server name/IP. in DNS we'll just put an alias to have the old server point to the new IP.

All that's left for me is transfering the Logins, and Links etc..

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources