Skip to main content

How can we help you?

Druva Documentation

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

Workaround

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

  • Was this article helpful?