ACO0261I There are no backups for the server named {SQLServerName}

Troubleshooting

Problem

Error ACO0261I is witnessed when querying or attempting to restore a backup, even though the backup is successfully stored to and exists on the Tivoli Storage Manager Server.

Symptom

C:\Program Files\Tivoli\TSM\TDPSql>tdpsqlc.exe q tsm master /SQLSERVER=SQL-TST-SERVER-DB\INST2

IBM Tivoli Storage Manager for Databases:
Data Protection for Microsoft SQL Server
Version 7, Release 1, Level 2.01
(C) Copyright IBM Corporation 1997, 2015. All rights reserved.

Connecting to TSM Server as node 'SQL-NODE'...

ACO0261I There are no backups for the server named SQL-TST-SERVER-DB\INST2

Cause

The computer name is greater than the maximum 15 characters that is allowed for the NetBios name by Microsoft. Since the SQL Server will use the NetBios name to identify its instances (i.e., NetBios-name/Instance-name), the limitation also affects the SQL Server.

Diagnosing The Problem

A diagnostic trace from the Data Protection for SQL client will show the SQL Server name is truncated during the backup:

Notice the SQL Server instance name is truncated at 15 characters "SQL-TST-SERVER-" instead of showing the full 17 character name "SQL-TST-SERVER-DB".

Running a QUERY FILESPACE for the SQL-NODE will show that the filespace name is also truncated.
For example: FILESPACE_NAME: SQL-TST-SERVER-\INST2\data\0001

Resolving The Problem

As noted in the following Microsoft document, the computer name is limited to a maximum of 15 characters:
https://support.microsoft.com/en-us/kb/909264

When a Microsoft SQL Server is installed on the system, it will use the NetBios computer name for the SQL Server name. If the computer name is greater than the 15 character limit, the SQL Server name will be truncated during the backup processing by the Data Protection client. As a result, the backup performed by the Data Protection for SQL client, will create/use the 15 character value for the filespace name.

Even though the SQL Server backups are stored with a truncated filespace name, they are still valid and can be restored. When performing the query, include the SQLSERVER= parameter with the truncated name. For example:
tdpsqlc.exe q tsm master /SQLSERVER=SQL-TST-SERVER-\INST2

It is recommended to ensure that the computer name is within the 1-15 characters limit that is supported by Microsoft.

[{"Product":{"code":"SSEQVQ","label":"IBM Spectrum Protect"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"IBM Spectrum Protect for Databases","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"Version Independent","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]

Product Synonym

TSM FCM

Was this topic helpful?

Document Information

Modified date:
01 February 2022

UID

swg21967472

Tips