Problem description
User databases gets skipped during SQL application aware 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 application aware backups do not support SQL filestream databases. Refer the article.
Workaround
If you want to backup the file stream database, install a SQL agent on the server and configure it for SQL backup. Refer the MS-SQL Key Considerations.