Search This Blog

January 9, 2008

SQL Server 2005: Data files are always under MSSQL.n\MSSQL\Data folder

If you use UI or command line to install SQL server 2005, data files are placed under MSSQL.n\MSSQL\Data .

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: