Problem description
User databases gets skipped during SQL Appaware backup
Cause
Skipped databases are part of Filestream data type.
Traceback
Phoenix-SQL-20230130_8983-1675103292_sqlguestplugin.log
[2023-01-30 18:06:10,246] [INFO] Skipping db with filestream [GSGBDC15001\DBSYSMON:NetPerfMon]
How to verify Filestream database?
Run the below query to find if any filestream file in that database in SQL Management Studio:
SELECT db.NAME AS DBName, type_desc AS FileType, physical_name AS Location FROM sys.master_files mf INNER JOIN sys.databases db ON db.database_id = mf.database_id WHERE type_desc = 'FILESTREAM'
Resolution
SQL Server AppAware backups do not support SQL filestream databases.
Reference Article: https://docs.druva.com/Phoenix/030_C...nes_for_backup
Workaround
If you want to backup the file stream database, install a SQL agent on the server and configure it for SQL backup instead
Druva Phoenix supports file-stream database backup.
Reference Article: https://docs.druva.com/Phoenix/030_C...Support_Matrix