User Tools

Site Tools


Sidebar

Announcement

Ahsay Backup Software

Backup Set Types

Supported Storage

Features in OBM / ACB

Features in CBS

Brand and Customize

License

Documentation

Performance Testing

FAQs and Known Issues

Can't Find What You Need?

public:5323_sql_device_name_provided_exceeds_supported_limit

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: 7.3.0.0 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.
* ... ... ...

Cause

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.

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

Resolution

To resolve the issue:

Keywords

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