Hi guy,
pretty new to this forum and VSS writers....
We are currently using Veeam backup product that use VSS SQLwriter and other vss writers to take it backup on a replication job inside veeam. But for some reason the VSS still see a .mdf file that was deleted and shoud not be available. We had to bring back file to be sure our replication/backup job work.
I even attach back the db in sql studio and delete it from the studio..but the error is still there...
In sqlwriterlogger.txt we can see this:
Database C:\USERS\PUBLIC\DOCUMENTS\XXXXX\YY\ZZZZ\_BAK\HHHH\_TEMP\TAG\AAAA.MDF on instance BBBBBB\LOCALDB#DDC88F12 found in metadata
[10/14/2022 10:25:18, TID bf0] Database C:\USERS\PUBLIC\DOCUMENTS\XXXXX\YY\ZZZZ\_BAK\HHHH\_TEMP\TAG\AAAA.MDF on instance BBBBBB\LOCALDB#DDC88F12 found in metadata
...
...
...
Error message: Unable to open the physical file "C:\USERS\PUBLIC\DOCUMENTS\XXXXX\YY\ZZZZ\_BAK\HHHH\_TEMP\TAG\AAAA.MDF". Operating system error 2: "2(The system cannot find the file specified.)".
Where real path section was replaced for confidentiality.....
So i understand the error basically is the file not found, but i looking to found why the file is still in the metada and how to correctly get rid of it....
Is there any tool or way to flush metada ? any sql configuration that still have that particular file into.....
I hope this community can help me on that to solve this issue.
Thank in advance
