Backup MSSQL databases

[Josef Weisskopf]

Hello,

I want to backup multiple MSSQL databases.

I read (not in the bareos docs) this directive in a file set should backup all databases:

Plugin = "mssqlvdi:instance=INSTANCENAME"

However I get this error:

  test-fd JobId 5378: Cannot open "/@MSSQL/SQLEXPRESSTEST//db-20250303-150001-full.bak": ERR=Bad file descriptor (errno=9 | win_error=0x000000CB).
  test-fd JobId 5378: Fatal error: Die -Datenbank ist nicht vorhanden. Stellen Sie sicher, dass der Name richtig eingegeben wurde.

Also something like this should work, is that true? My tests are failing as well. Maybe this is a bacula feature only.

Plugin = "mssqlvdi:instance=INSTANCENAME:include=TEST01:exclude=TEST02"

  test-fd JobId 5381: Fatal error: Illegal argument include with value TEST01 in plugin definition

Is there any option to have a more flexible setup than including all databases manually. This could be even more critical if someone else adds a new database which is forgotten to be included in the bareos configuration.

Thanks in advance for any suggestions.

I

[Bruno Friedmann (bruno-at-bareos)]

In Bareos documentation you have this clear statement

For every database separate job and FileSet are required.

Which also point to the fact that there's no exclude/include mechanism.
I propose that you open a discussion for enhancement https://github.com/bareos/bareos/discussions

[Josef Weisskopf]

Hello Bruno,

thanks for your answer.

Of course I read a docu before asking a forum and I new this statement.

However sometimes there exist non-documented or non-supported features which do a job perfectly 🤷‍♂️.

kr