"amnésia" <se*************************************@nondireca zzate.it> wrote in message news:<cd**********@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
amnésia
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.
