April 3, 2006 at 12:42 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 3, 2006 at 1:25 pm
Sorry for the post, didn't realize this was SQL 2005
April 4, 2006 at 10:10 am
Just a remainder. If your OS is Windows Server 2003 R2 (x64). There is an undocumented issue with SQL server DTC. If you need DTC, you need to call Microsoft so that they can walk you through to fix it.
April 4, 2006 at 10:30 am
One minor thought. You'll want to make sure that you put your paging file on a different set of spindles and, if possible, a different channel from your data. No point having paging operations getting in the way of data access.
Just as a thought, why not just have the OS boot off disks in the box, say set up a RAID 1? Make sure to backup system state regularly, and then you don't eat up space and time on your SAN with OS stuff, which is simple enough to rebuild anyway.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply