Error while upgrading SQL server 2012 to SQL 2017 : Failed to create a new folder 'X:\xxxx'. The specified path is invalid

Database Administrators Asked by SunilGoswami on October 28, 2021

Failed to create a new folder ‘X:MSSQLDATAMSSQL11.MSSQLSERVERMSSQLLOG’. The specified path is invalid (for example, it is on an unmapped drive).

I checked there is no X drive present in the server. I verified that all the default files for data and log points to the drives which are available in the server.

Not sure , how do I resolve this as i don’t see X drive mentioned in any of the properties.

I have checked in Facets and database properties to verify the path.

sql server sql server 2017

One Answer

At the first sign of trouble during an in-place upgrade, fallback to a side-by-side upgrade. Install a new instance of SQL 2017, preferably on a new VM, and migrate the databases, logins, jobs and settings from your old instance.

Answered by David Browne - Microsoft on October 28, 2021

Add your own answers!

Ask a Question

Get help from others!