mssql plugin : Fatal error: The identifier that starts with ...is too long. Maximum length is 128.

[Alexandre Derumier]

Hi,

I have backup error with mssql plugin on a new mssql server 2014:

plugin config:

Plugin = "mssqlvdi:instance=default:database=[xxxx_xxxx_xxxxx]:username=xxx:password=xxxxxxxxx:replace=yes:norecovery=yes:recoverafterrestore=yes:serveraddress=xxxxxx"

I don't have this error on another sql 2014 server, don't known if it's need a sql configuration or if it's a bug in plugin

logs:

Fatal error: mssqlvdi-fd: IClientVirtualDeviceSet2::GetConfiguration failed
03-juin 16:18 mindbdd0-fd JobId 473712: Fatal error: The identifier that starts with '[Regiepub_016_Cado_Hitech] TO VIRTUAL_DEVICE='{2C2168A4-0B1B-4639-A559-36832B88C874}' WITH BLOCKSIZE=65536, BUFFERCOUNT=10, MAXT' is too long. Maximum length is 128.
Unclosed quotation mark after the character string '[xxxx_xxx_xxxx] TO VIRTUAL_DEVICE='{2C2168A4-0B1B-4639-A559-36832B88C874}' WITH BLOCKSIZE=65536, BUFFERCOUNT=10, MAXTR'.
Incorrect syntax near '[xxxx_xxx_xxxx] TO VIRTUAL_DEVICE='{2C2168A4-0B1B-4639-A559-36832B88C874}' WITH BLOCKSIZE=65536, BUFFERCOUNT=10, MAXT'.

Fatal error: The identifier that starts with '[Regiepub_100_Test] TO VIRTUAL_DEVICE='{546396FB-751A-42D2-8780-6D90C2BD1F9A}' WITH BLOCKSIZE=65536, BUFFERCOUNT=10, MAXTRANSFER' is too long. Maximum length is 128.
Unclosed quotation mark after the character string '[xxxxxxx_xxxx_xxxx] TO VIRTUAL_DEVICE='{546396FB-751A-42D2-8780-6D90C2BD1F9A}' WITH BLOCKSIZE=65536, BUFFERCOUNT=10, MAXTRANSFERS'.
Incorrect syntax near '[xxxxxxx_xxxx_xxxx] TO VIRTUAL_DEVICE='{546396FB-751A-42D2-8780-6D90C2BD1F9A}' WITH BLOCKSIZE=65536, BUFFERCOUNT=10, MAXTRANSFER'.

03-juin 16:19 mindbdd0-fd JobId 473713: Cannot open "/@MSSQL/default/[Regiepub_100_Test]/db-20160603-161820-full.bak": ERR=The operation completed successfully.
.

[Alexandre Derumier]

ok, I have found the problem.

this is since this commit:
https://github.com/bareos/bareos/commit/8ebd89082bd6bb69d92446fc22865176ce855ef4

which add [ ] for database name for database with name.

I already used [dbname] in config, so with this commit, i got [[dbname]].

I have fixed my config.