Skip to main content


 

 

How can we help you?

 

Druva Documentation

User databases gets skipped during SQL Appaware backup

Heads up!

We've transitioned to a new documentation portal to serve you better. Access the latest content by clicking here.

 

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?