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
amnésia

"amnésia" <secondotetidoilmioindirizzocosilospammi (AT) nondirecazzate (DOT) it> wrote

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.

amnésia (secondotetidoilmioindirizzocosilospammi (AT) nondirecazzate (DOT) it) writes:
Could try playing with the registry keys in
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ Setup.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

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