63201: Acronis Backup: "Error: Trailing spaces in the path" when backing up SQL database

use Google Translate

Symptoms

  1. You use Acronis Backup 12.5 or Acronis Cyber Cloud
  2. You run a backup of a Microsoft SQL database
  3. Backup fails with the following error:

Problems detected that may cause a VSS snapshot failure. Trailing spaces in the path. To remove the trailing spaces, run the T-SQL command: ALTER DATABASE MODIFY FILE

Cause

Acronis Backup products check the database paths before backup to ensure snapshot consistency.

If the path to the database contains an extra space in the database path, the snapshot creation will fail.

Solution

The issue will be fixed in next updates of Acronis products. 

Use the following workaround to fix the issue with database path:

SQL server restart may be required in order for the changes to take place. 

1. Open SQL Server Management Studio (make sure that SSMS version matches the version of SQL instance running on the machine)

2. Run the following query to get the list of database names and locations:

USE <database_name>

SELECT * FROM sys.database_files 

3. In the output, find the database that is mentioned in the warning

4. Run the following command to modify physical path to the file:

ALTER DATABASE <database name>

MODIFY FILE (NAME = '<logical name>', FILENAME='<path to file>');

where

<database name> is the name of the database that is mentioned in the error, no changes needed
<logical name> is the logical name of the file mentioned in the error, no changes needed
<path to file> is the full path to the file that is mentioned in the error, without double slashes or extra spaces at the end 

Tags: 

You are reporting a typo in the following text:
Simply click the "Send typo report" button to complete the report. You can also include a comment.
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.
3 + 2 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.