Cause

• The database MDF file has a blank space ” “ before the file name in it.

Eg: “ database_name.MDF” instead of “database_name.MDF”. 

• This was not getting recognized by the windows system while presenting to the Druva.
• This was getting presented as “D:\\databasepath\\database_name.MDF” and while running the discovery process it was not able to find the same path as it’s actually not the absolute path of the file. 

Traceback

Backup Log:
==========
2022-08-30 02:35:29,267] [ERROR] Got error while taking SQL snapshot.
[2022-08-30 02:35:29,285] [WARNING] Error occurred while taking SQL snapshot 4295032853 Got error while taking SQL snapshot.: 10.xxx.xx.xx. Application aware backup would have just VM backup and would complete with Successful with errors

SQL App-Aware log :
================
[2022-08-30 02:35:24,441] [ERROR] Error in Executing sql discovery
[2022-08-30 02:35:24,457] [ERROR] Error <type 'exceptions.WindowsError'>:[Error 2] The system cannot find the file specified: u'D:\\DATABASES\\PFMEINS003\\DATA\\UMDB_ID_EUCLID_DATA.MDF'. Traceback -Traceback (most recent call last):
File "app_aware_lib\sql\sqlguestplugin\sql_helper.py", line 845, in run_discovery
File "app_aware_lib\sql\sqlguestplugin\sql_helper.py", line 652, in get_discovery_info
File "app_aware_lib\sql\sqlguestplugin\sql_helper.py", line 690, in _get_instances_info
File "app_aware_lib\sql\sqlguestplugin\sql_helper.py", line 711, in _add_db_size_in_all_db_info_dict
File "app_aware_lib\sql\sqlguestplugin\sql_helper.py", line 729, in _calculate_db_size
WindowsError: [Error 2] The system cannot find the file specified: u'D:\\DATABASES\\PFMEINS003\\DATA\\UMDB_ID_EUCLID_DATA.MDF'

See also

https://docs.microsoft.com/en-us/tro...ace-characters