Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Symptoms

Note

List the symptoms of the problem

When configuring a Microsoft SQL Server backup set, both of the following are true:

  • The list of databases does not appear in the "What would you like to back up?" section of the main Backup page.
  • The message "Internal error" appears above or below the area where the list of databases should appear.

What's going on?

Note

Provide a brief explanation of what is causing the problem

Resolution

Note

Provide the steps to solve the problem

Warning

Don't forget to add labels to the article!

Help us improve this article!

ZCB uses the SQL VSS Writer to generate the list of databases to be backed up. The "Internal error" message is generated instead of a list of databases when the SQL VSS Writer is not available.

Resolution

Open an elevated (run as administrator) command prompt and run the following command: vssadmin list writers

  • A list of VSS Writers will appear.
  • Verify that a writer named SQLServerWriter is included in this list.

 

Expand
titleClick here to see example output from 'vssadmin list writers'

In this screenshot, the SQLServerWriter is properly listed:

Image Added

In this screenshot, the SQLServerWriter is not listed at all:

Image Added

If the SQL VSS Writer is not listed, action must be taken before it is possible to configure the Microsoft SQL Server backup set.

Begin by ensuring that the Volume Shadow Copy service and the SQL VSS Writer service are running on the system.

In Services.msc, do the following:

  • Verify that the Volume Shadow Copy service is running.
    • Start the service if it is not running.
    • If it is already running, please restart the service.
  • Verify that the SQL VSS Writer service is running. 
    • Start the service if it is not running.
    • If it is already running, please restart the service.

Once the services have been started or restarted, run the vssadmin list writers command again. If the SQL VSS Writer is still not listed, please refer to Troubleshooting SQL VSS Writer issues for further troubleshooting information.