User Tools

Site Tools



Ahsay Backup Software

Backup Set Types

Supported Storage

Features in OBM / ACB

Features in CBS

Brand and Customize



Performance Testing

FAQs and Known Issues

Can't Find What You Need?


ISSUE: The length of the device name provided exceeds supported limit (maximum length is:259) (MS SQL database backup)

Article ID: 5323
Reviewed: 21/03/2018

Product Version:
AhsayOBM: or above
OS: Windows

Problem Description

When performing a MS SQL database backup (ODBC backup mode), the following error message is received in the backup report:

No. Type Timestamp Log
* ... ... ...
* info ... [Start] Backing up "SQL_hostname\...\long_db_name" ... to "temp_path\long_db_name"
* warn YYYY/MM/DD hh:mm:ss [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid device name. The length of
the device name provided exceeds supported limit (maximum length is:259). Reissue
the BACKUP statement with a valid device name.
* ... ... ...


This is a warning message returned by the SQL server, suggesting that length of the directory path to the backup device (e.g. temporary folder path plus the database name) exceeded 259 characters.

The maximum number of characters is a limit imposed by the SQL server and not AhsayOBM.


To resolve the issue:


sql, odbc, exceed, exceeds, exceeded, max, maximum, char, character

public/5323_sql_device_name_provided_exceeds_supported_limit.txt · Last modified: 2018/03/21 15:48 by edward.chan