User databases gets skipped during SQL Appaware backup
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