Changing drive letter

Hi there. I have to change the drive letter where SQL server have his
datfiles (master included). If I do that, ob the SQL fail to start, becouse
it's unable to find the master datfiles. Is it possible changing driver
letter without reinstalling the complete product?

BR
amnsia"amnsia" <secondotetidoilmioindirizzocosilospammi@.nondirecaz zate.it> wrote in message news:<cdqqkq$cmj$1@.domitilla.aioe.org>...
> Hi there. I have to change the drive letter where SQL server have his
> datfiles (master included). If I do that, ob the SQL fail to start, becouse
> it's unable to find the master datfiles. Is it possible changing driver
> letter without reinstalling the complete product?
> BR
> amnsia

From KB224071

Moving the master database
Change the path for the master data and log files in SQL Server Enterprise Manager.

NOTE: You may optionally change the location of the error log here as well.
Right-click the SQL Server in Enterprise Manager and click Properties.
Click the Startup Parameters button and you will see the following entries:
-dD:\MSSQL7\data\master.mdf
-eD:\MSSQL7\log\ErrorLog
-lD:\MSSQL7\data\mastlog.ldf

-d is the fully qualified path for the master database data file.

-e is the fully qualified path for the error log file.

-l is the fully qualified path for the master database log file.
Change these values as follows:
Remove the current entries for the Master.mdf and Mastlog.ldf files.
Add new entries specifying the new location:
-dE:\SQLDATA\master.mdf
-lE:\SQLDATA\mastlog.ldf

Stop SQL Server.
Copy the Master.mdf and Mastlog.ldf files to the new location (E:\Sqldata).
Restart SQL Server.|||amnsia (secondotetidoilmioindirizzocosilospammi@.nondireca zzate.it) writes:
> Hi there. I have to change the drive letter where SQL server have his
> datfiles (master included). If I do that, ob the SQL fail to start,
> becouse it's unable to find the master datfiles. Is it possible changing
> driver letter without reinstalling the complete product?

Could try playing with the registry keys in
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ Setup.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp