SQL Server Home
File Paths used by upgrade
6/9/2008 4:36:04 PM
User(s) can reproduce this bug
We are testing upgrades from SQL Server 2005 to SQL Server 2008 and have run into some problems with the paths.
For a cluster, the file path for SQLBinRoot was F:\MSSQL.1\MSSQL\Binn. After the upgrade, the path is changed to C:\MSSQL10.MSSQLSERVER\. The upgrade cannot change the drive letter location of SQLBinRoot and other SQL drives. It needs to leave the files on the F: drive.
For a standalone server, SQLBinRoot was F:\MSSQL.1\MSSQL\Binn. After the upgrade, the path is changed to F:\MSSQL10.MSSQLSERVER\MSSQL\Binn, as expected. However, our standard installation puts the SQLDataRoot and other paths on another location: F:\SQLCatalog\MSSQL.1\MSSQL. After the upgrade, it is using the same MSSQL.1 location. I expected it to change to the MSSQL10.MSSQLSERVER format.
SQL Server 2008 June CTP
Win2003 Enterprise Server (SP2)
Operating System Language
Steps to Reproduce
1. Install SQL Server 2005 and put the SQLBinRoot on F:\SQLCatalog\MSSQL.1\MSSQL (or on a drive other than the C: drive.)
2. Perform the SQL Server 2008 upgrade.
1. Install SQL Server 2005 and put the SQLBinRoot in F:\MSSQL.1\MSSQL\Binn and SQLDataRoot in F:\SQLCatalog\MSSQL.1\MSSQL
2. Perform the SQL Server 2008 upgrade
See Description - on 32-bit and 64-bit servers.
to post a comment.
Please enter a comment.
on 6/26/2008 at 2:33 PM
We have verified the fix for RTM and closed this bug.
Thanks again for your feedback!
on 6/25/2008 at 7:58 AM
We have fixed this issue for RTM. Thanks for your feedback!
on 6/12/2008 at 10:36 AM
As we investigated this issue, we also repro'ed the same problem.
However, although the UI shows C:\ drive as the binary installation location for the new upgraded instance, they are actually placed in the F:\ drive.
Do you still have the logs from our test and attach them to this bug? Could you also check if binaries from the upgrade have been really placed in the C:\ drive or F:\ drive?
to post a workaround.
Please enter a workaround.
© 2014 Microsoft