AhsayOBM: 22.214.171.124 or above
When performing a MS SQL database backup (ODBC backup mode), the following error message is received in the backup report:
|*||info||...||[Start] Backing up "SQL_hostname\...\long_db_name" ... to "temp_path\long_db_name"|
[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