Resolving the failed SQL Server database backup

Edit online

When the SQL Server backup job is failed and the server reports an error, you can resolve the issue and enable the backup job by an alternate approach.

About this task

The backup job failure may occur because of the server fails to initialize the volumes for backup. An error that occurs is similar to the following example:
Error: ('6' 'MI_RESULT_NOT_FOUND: The requested object cannot be found.')

Procedure

To enable the backup job by an alternate approach:
  1. Open the Remote Desktop Protocol (RDP) session to the SQL Server.
  2. Navigate to the following location: C:\ProgramData\SPP\
  3. Create the usevds file as shown in the following file path: C:\ProgramData\SPP\usevds, which can be empty.
  4. Close the RDP session.