We are upgrading from sql 2000 Standard edition to sql 2005 developer edition using in-place upgrade method.
1.SQL 2000 datafiles are located at D:\MSSQL Server2000\MSSQL\DATA. When installing sql 2005, I choose Installation Path as D:\Microsofr SQL Server2005.
So my question for inplace upgrade DO I need to choose the same path as sql 2000 is installed D:\MSSQL Server2000 or I can choose different path like D:\Microsofr SQL Server2005.Because in-place upgrade overwrites the sql 2000 datafiles,so What path should i choose here?
please advice me..