VSS Writer issue - SqlServerWriter present, but not showing any Component/DB

Dries Beerts 0 Reputation points
2023-04-06T10:40:54.7966667+00:00

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!

Windows for business | Windows Server | Devices and deployment | Set up, install, or upgrade
Windows for business | Windows Server | User experience | Other
SQL Server | Other
{count} votes

1 answer

Sort by: Most helpful
  1. Seeya Xi-MSFT 16,586 Reputation points
    2023-04-07T01:54:25.6133333+00:00

    Hi @Dries Beerts ,

    You can try to restart SQL Server service in SQL Server Configuration Manager to fix this issue. If this does not solve the problem, you need to contact Veeam's technical support. Good luck!

    I found it from google: https://www.veeam.com/support.html?ad=in-text-link

    Best regards,

    Seeya


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.