Knowledge Base & Discussion Forum

Invalid device name

Discuss issues about AhsayOBM's MS SQL Server Database backup and restore

Moderator: Support Team

Invalid device name

Postby valentin.ciobanu » Mon Nov 16, 2015 8:49 pm

Hello ,

I have a backupset of a Microsoft SQL Database and i get this warning:

[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.

I know what the warning says but i want to know if i can do something to get rid of it :)\

Thank you !
valentin.ciobanu
 
Posts: 5
Joined: Wed Aug 05, 2015 9:10 pm
Location: Bucharest

Re: Invalid device name

Postby Support2 » Thu Nov 19, 2015 7:27 pm

Hello

The error message is returned by MS SQL Server when it tried to spool a copy of the database to the temporary folder.

As the message suggests the length of the path + database name exceeds 259 characters. I would suggest relocate the database to another location where the path + database name is less than 259 characters
User avatar
Support2
 
Posts: 390
Joined: Thu Oct 18, 2007 5:53 pm

Re: Invalid device name

Postby valentin.ciobanu » Fri Nov 20, 2015 7:42 pm

Thank you very much for the suggestion , i will try moving the database and tell you if it`s okay.
valentin.ciobanu
 
Posts: 5
Joined: Wed Aug 05, 2015 9:10 pm
Location: Bucharest


Return to Microsoft SQL Server Database

Who is online

Users browsing this forum: No registered users and 0 guests

Looking for Rbackup Alternative | Vembu Alternative | Novastor Alternative | Asigra Alternative | BackupAgent Alternative? Try our product.


A wholly owned subsidiary of Ahsay Backup Software Development Company Limited  [HKEx Stock Code: 8290]