April 3, 2006 at 1:26 pm
Hey Guru's,
I have a quick question
We have a...
DL380 G2 32-bit server running Windows 2000 Server and SQL Server 2000
When the SAN is installed, we would LIKE to have (we have a quote pending) a...
DL380 G4 dual processor (dual-core) 64-bit server running Windows 2003 Server but still SQL Server 2000 (We already have the appropriate SQL processor licenses). The OS would be rebuilt with Windows 2003 and would be booted from the SAN. The SQL 2000 installation would be redone and appropriately patched. We would then detach and reattach our databases from the old environment to the new environment.
I need to know if there are any hardware/software related issues with this approach...
I.E.
Can I restore SQL 2000 databases (from the same version of SQL) that were running on Windows 2000 to Windows 2003?
And if so, do I need a 64-bit version of Windows 2003 server now?
How, if at all, does that impact a SQL 2000 installation...
Etc...
April 4, 2006 at 2:53 am
There are no issues detaching/attaching (or restoring) SQL2000 database files across different operating systems. The internal format of the database files is the same regardless of operating system or bit-level of SQL, but can be affected by the SQL Server patch level.
Likewise you can detach/attach SQL2000 databases to SQL2005, but you may not always be able to go the other way.
If you are planning to use 64-bit SQL2000, you should test that all the functionality you need is supported at 64-bit. MS only ported a subset of SQL2000 to 64-bit, for example DTS does not run on SQL2000 64-bit. You will also see there are many more fixes for SQL2000 32-bit than 64-bit, but you should not assume that SQL2000 64-bit is free of those problems.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply