Hi,
I'm having a back-up issue with a database server. Veeam uses VSS Writers to create an Application Aware (consistent) back-up. After a 'successful' back-up, I noticed that the backup info within SSMS wasn't updated. Also I couldn't find any logs within SQL or Event Viewer regarding the Database back-ups. When looking in Veeam, it also didn't recognize the backup as an SQL backup.
After some troubleshooting, also with Veeam, we saw something strange happening with the VSS writer.
The SqlServerWriter is present and in a correct state. However, when you perform a 'list writers' within diskshadow, it should list all components/DB's of this writer. In our case nothing is displayed:
* WRITER "SqlServerWriter"
- Writer ID = {a65faa63-5ea8-4ebc-9dbd-a0c4db26912a}
- Writer instance ID = {d7cbaf90-692f-46cd-ab89-4865d27f8f6c}
- Supports restore events = TRUE
- Writer restore conditions = VSS_WRE_ALWAYS
- Restore method = VSS_RME_RESTORE_IF_CAN_REPLACE
- Requires reboot after restore = FALSE
- Excluded files:
* WRITER "ASR Writer"
This causes Veeam to complete without any error because the info from VSS states there are no SQL databases present on the server.
I already tried a full repair of SQL, unfortunately without success.
Does anyone has a clue? I have spent a lot of time searching for a similar issue on the web but couldn't find anything related.
Thanks in advance!