VSS Sqlwriter metada still see a deleted db file

Copper Contributor

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

 

 

 

0 Replies