Symptoms
When you try to use Clustered Shared Volumes (CSV) as a source or destination in performing a backup or restore database activity in Microsoft SQL Server 2014 Management Studio (SSMS 2014), you receive the following error message:
<file path of the backup file>
Cannot access the specified path or file on the server. Verify that you have the necessary security privileges and that the path or file exists. If you know that the service account can access a specific file, type in the full path for the file in the File Name control in the Locate dialog box.
Resolution
The issue was first fixed in the following cumulative updates for SQL Server:
Cumulative Update 1 for SQL Server 2014 SP1
Cumulative Update 8 for SQL Server 2014
Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included in the previous cumulative update. Check out the latest cumulative updates for SQL Server:
Workaround
To work around this issue, use one of the following methods:
-
Use TSQL statements to perform the backup or restore database activity in a new query window.
-
Instead of browsing to the CSV path manually, enter the path and file name in the Backup or Restore Database wizard when you select the location.
Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
