Upgrading from SQL 2000 to SQL 2005
Will you need to purchase a new server to upgrade SQL 2005?

Answer Question   |  September 8, 2010  3:23 PM
SQL Server 2000 to SQL Server 2005 upgrade, SQL Server 2005, SQL Server Hardware

Upgrading SQL Server 2000/2005 to 2008 with VMWare and EMC SANs
Has anyone ever seen a White Paper on the best way to utilize features of both VMWare and EMC Symmetrix based SANs in a real-time or rapid batch based upgrade from SQL Server 2000/2005 to SQL Server 2008 with minimal downtime for application availability?

Answer Question   |  August 27, 2010  4:47 PM
EMC SAN, EMC Symmetrix, EMC Symmetrix DMX-4, SAN, SQL Server 2000, SQL Server 2000 to SQL Server 2005 upgrade, SQL Server 2005, SQL Server 2005 upgrade, SQL Server 2008, SQL Server Upgrade, Symmetrix, VMware, Windows Server 2008

SQL 2000 migration to SQL 2005 – need to preserve user security
Hi, I have a customer that is planning on moving to new hardware and performing a SQL upgrade (2000->2005).  I know that our application (FileNet Image Services) is sensitive to what we refer to as an “orphaned” database.  Our app stops working if a database is simply detached/attached to another server because it loses that [...]

Answer Question   |  June 17, 2010  2:24 PM
SQL Database Security, SQL Server 2000 to SQL Server 2005 upgrade, SQL Server security, SQL Server Upgrade

SQL 2000 Upgrade
I am upgrading four sql servers 2000 to 2005. If i do an inplace upgrade to the default instance would i need to change any passwords for linked servers, services or sql accounts?

Answer Question   |  May 29, 2009  4:23 PM
SQL Server 2000, SQL Server 2000 to SQL Server 2005 upgrade, SQL Server 2005, SQL Server upgrades, Upgrade from SQL Server 2000 to SQL Server 2005

SQL Server 2000 DTS Designer components are required to edit DTS packages Error even after installing sqlserver2005_dts.msi
Hi, I am new to Database Technology and was asked to upgrade from MS SQL Server 2000 to 2005. I followed the procedure regarding the upgration found in one of the posts.THe Upgrade advisor says “SQL Server 2000 DTS Designer components are required to edit DTS packages” and In how to resolve this we were [...]

Answer Question   |  December 2, 2008  2:24 PM
SQL Server 2000, SQL Server 2000 to SQL Server 2005 upgrade, SQL Server 2005, SQL Server Upgrade

Log shipping after upgrading to SQL Server 2005
I’ve upgraded our warm backup to SQL Server 2005 recently, but our log shipping is down. How can SQL Server 2005 be used with SQL Server 2000 log shipping?

Answer Question   |  November 11, 2008  7:06 PM
Log Shipping, SQL Server 2000, SQL Server 2000 Log Shipping, SQL Server 2000 to SQL Server 2005 migration, SQL Server 2000 to SQL Server 2005 upgrade, SQL Server 2005, SQL Server upgrades