47131: Acronis Backup Advanced 11.7/11.5: Single-pass Backup Fails with "Cannot get the instance path from Microsoft SQL Server"

use Google Translate

Change the name of your SQL server.

Symptoms

  1. You create a backup plan with single-pass enabled to backup SQL databases.
  2. Backup fails with:
    Error code: 61 
    Module: 309 
    LineInfo: 4a8728dc8a1c950f 
    Fields: $module : service_process_vs_38350 
    Message: Command 'Backing up' has failed. 
    -------------------- 
    Error code: 54 
    Module: 482 
    LineInfo: 5c71ebf434f0c47a 
    Fields: $module : disk_bundle_vs_38350 
    Message: Failed to collect all of the data required for single-pass backup of Microsoft SQL Server. 
    -------------------- 
    Error code: 4353 
    Module: 87 
    LineInfo: e4fe5c9fd5e63dde 
    Fields: $module : aaib_mssql_backuper_vs_38350 
    Message: Cannot back up SQL Server databases of instance 'MSSQLSERVER'. 
    -------------------- 
    Error code: 27 
    Module: 87 
    LineInfo: b19b368b2754d504 
    Fields: $module : ArsAgentProvider_vs_38350 
    Message: Cannot get the instance path from Microsoft SQL Server.

Cause

It seems that the SQL Server machine name was changed and therefore we are unable to find the actual instance of SQL server.

You can verify it this way:

  • Start SQL Server Management Studio and connect to the instance mentioned in the error message.
  • Select New Query.
  • Query "SELECT @@SERVERNAME AS Instance_Path".
  • The Query will return NULL intead of actual server name.

Solution

Change the name of your SQL server to the current one.

  1. Start SQL Server Management Studio and connect to the instance mentioned in the error message.
  2. Select New Query.
  3. Execute "select * from sys.servers where server_id=0" and see if it returns something. If the result is empty go to step 5.
  4. Execute:
    USE master;
    EXEC sp_dropserver 'OLDSERVERNAME';
    (where OLDSERVERNAME is the server name as listed in the name column)
  5. Execute:
    USE master;
    EXEC sp_addserver 'NEWNETWORKNAME','LOCAL';
    (where NEWNETWORKNAME is the new networkname you want to assign to the server)
  6. Restart your SQL server instance (right-click on the instance -> restart).

More information

Please contact Acronis Customer Central if you need assistance.

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.
9 + 2 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.