Microsoft SQL database restore can fail with the error ‘0xe000fee5 - A failure occurred restoring because the files cannot be replaced and no alternate location was specified.’

book

Article ID: 100049596

calendar_today

Updated On:

Description

Error Message

A Microsoft SQL database restore fails with the below error:
0xe000fee5 - A failure occurred because the files cannot be replaced and no alternate location was specified.
 

Cause

This error can be seen if the database being restored has a FILESTREAM associated that is located in a path longer than 160 characters.
 

Resolution

Run a redirect restore of the database to a path that is shorter than 160 characters.
 

Issue/Introduction

Microsoft SQL database restore can fail with the error ‘0xe000fee5 - A failure occurred restoring because the files cannot be replaced and no alternate location was specified.’ when the database has an associated FILESTREAM in a path that is longer than 160 characters.

Additional Information

ETrack: 4020535