Skip to main content
User databases gets skipped during SQL Appaware backup
Updated over a week ago

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

Workaround

If you want to backup the file stream database, install a SQL agent on the server and configure it for SQL backup instead

Did this answer your question?