Sql-server – Error when upgrading SQL Server from 2012 (sp3) to 2014

sql serversql server 2014sql-server-2012

I am attempting to upgrade MS SQL Server 2012 (sp3) to SQL Server 2014.

At the end of the upgrade several components fail with an error that says,

"Error details: Error installing SQL Server Database Engine Services
Instance Features Failed to create a new folder
'H:\MSSQL11_MSSQLSERVER_Backup_Dir'. The specified path is invalid
(for example, it is on an unmapped drive). Error code: 0x84CF000E"

This server does not have an H:\ drive. As far as I know, it never did have an H drive. How can I correct this?

Best Answer

Run this

EXEC master.dbo.xp_instance_regread
N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer',N'BackupDirectory'

to see what your default backup directory is set to.

This can also be viewed in Management Studio by right clicking on your instance, selecting Properties and going to the Database Settings tab. It will be near the bottom under Database default locations. If your default backup directory is set to 'H:\MSSQL11_MSSQLSERVER_Backup_Dir', changing it will help.

Related Question