If you specify INSTALLSQLDATADIR=”C:\mydata” and try to put data files under mydata folder, you probably feel disappointed.
After the install, it generates the path MSSQL.1\MSSQL\Data and attaches it to the above path; finally it becomes: “C:\mydata\MSSQL.1\MSSQL\Data”.
From this article (http://msdn2.microsoft.com/en-us/library/ms345408.aspx), master and resource DBs must be in the same location:
The Resource database depends on the location of the master database. If you move the master database, you must also move the Resource database to the same location as the master data file. Do not put the Resource database in either compressed or encrypted NTFS file system folders. Doing so will hinder performance and prevent upgrades.
Do you think it is an interesting issue?
No comments:
Post a Comment