Cannot change location of master database to mount point in startup parameters - by Karl Grambow

Status : 

  Not Reproducible<br /><br />
		The product team could not reproduce this item with the description and steps provided.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


1
0
Sign in
to vote
ID 748192 Comments
Status Closed Workarounds
Type Bug Repros 1
Opened 6/11/2012 2:53:55 AM
Access Restriction Public

Description

I'm unable to modify the startup parameter for the location of the master database using the SQL Server Configuration Manager, as described in BOL.

Interestingly, it appears to ONLY be failing if the path I enter is on a mount point.

I cannot change the location of any of the other startup parameters (location of error log file or master log file) to a mount point location.
Sign in to post a comment.
Posted by Karl Grambow on 10/23/2012 at 2:46 PM
Hi,

The mount does contain a dash - in the name.... here's the full parameter string:

-dE:\C1S1-SYS\MSSQL11.C1S1\MSSQL\Data\master.mdf

I was actually able to change the startup parameter using PowerShell so it's interesting that you say the "-" character is invalid because it's clearly a valid mount point name. Once changed with PowerShell, SQL Server accepts it as a valid path so it seems that it's only the configuration manager application that thinks it is invalid.

Posted by Microsoft on 10/12/2012 at 2:58 PM
Thanks for the feedback. Does your mount point contain any of the following characters:
-
/
;

These are considerred as invalid characters.
Also if possible, could tell me the whole parameter string?